Section Counter?

[adowen]

I have a table that lists the number of sections passed in a workbook. To add records into the table (signifying that the section was passed that day), the user places a checkmark in the checkbox.

I need to add a field to a query that will count the number of records for a person on a day to know the number of sections that they passed that day.

How would I do something like this?

Thanx in advance,

Adam

 

[jebry]

Hi Adam!

Try this(generic field names):

Select PersonID, Count(Sections) As NumberOfSections From YourTable Group By PersonID

hth
Jeff Bridgham
bridgham@purdue.edu