Count

[jaybarnard]

I having trouble trying to figure out how i can get totals in a report, the report picks the information up from a query i have set up. The report shows various data to do with Grades awarded as part of an audit process (1-4), i want to put a total in the report to count how many 1's, how many 2's etc. i not very experienced with access so can anybody help me with this.

 

[ghudson]

Lookup the DCount() function. The Access help file will give you examples and the proper syntax on how to use it.