Counting checkmarks across colums

mattmickle

Board Regular
Joined
Nov 17, 2010
Messages
81
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.
 
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).
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,223,909
Messages
6,175,310
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top