Filter Expression - Microsoft Community

i'm new access, i'm sure question along these lines has been asked before, can't find it.

i'm working on project analyzing voter turnout in state, working voter datasets each county. in dataset, there fields each election. if individual voted in election, marked x , left blank if did not. trying find out raw numbers of individuals voted in both elections i'm analyzing, , how many voted in 1 or other.

in other words, need create query give me total number of times there x in both fields, , queries give me number of times there x in field 1 not 2, , vice-versa. i'm sure pretty basic task, can't figure out. appreciated!

on create tab of ribbon, click query design.

access displays show table dialog.

select table, click add, click close.

access automatically activates design tab of ribbon.

click highlight totals in show/hide group.

add voter id or name field query grid, fields 2 elections.

by default, access sets total row group columns.

change count voter id/name field, , 2 election columns.

access automatically clears show check box latter 2 columns.

enter x in criteria row each election column. access changes x "x" because text value.

this query return count of voters participated in both elections. save query.

for count of voters participated in first election not in second, same, change second "x" to null:

for count of voters didn't participate in first election, did participate in second one, exchange "x" , null.

Office / Access / Windows 10