I hope I explain this correctly.


Is there a way to count how many times a particilar description is listed.

Example:

USAGE

Planned
UnPlanned
UnPlanned
Planned
UnPlanned TT Sick
UnPlanned TT Sick

Now, in my footer I want to count how many times "Planned" is listed and how many times "Unplanned" is list, ect...

Any help would be appreciated.

Create a totals query that produces the counts you want. Use this query as the RecordSource for a report. Add the new report to the original report's ReportFooter.

Thank you