Counting checkmarks across colums

[mattmickle]

Hi All,
Another noob Access question:

I have a table set up:
Dept ID#, Last Name, First Name, 01/01/19 (YES/NO column)

For each person, I'm checking "YES" if they were there on that date. The dates could be a couple days apart or weeks, you never know. So, basically, this is an attendance record with unknown dates and unknown people.

I'm looking for a way to count the "YES" check marks by person.
For example:

021 Mickle, M - Yes on 01/01/19, Yes on 01/14/19, No on 01/15/19, Yes on 01/23/19 = 3 Yesses.
I don't know how many dates I have, could have the same date twice (at 2 different times), but want to keep a running total of how many "Yesses" each person has.

I could whip this off in Excel in about 3 minutes, but everything else I have is in access so I'm trying to keep it there.

Any help is always appreciated.

 

[Joe4]

Make a new query, using the Aggregate Query you just created as its source, and add the calculated field there.

A lot of noobs don't fully grasp the power of queries. You can make "queries of queries", like we are doing here. Queries can also be used for just about anything that tables can (sources for Forms, Reports, and Exports).