displaying counts in report footer

[bellegia]

I have a table with a field that contains values of 1 thru 5, I would like to produce a report that counts the number of each value and displays it on the report without having to create queries for counts of each value and then reference the queries in the report. I have attempted to enter an expression in a report footer field. ex)
=count(fieldname)=1 does not work.
Please help. Thank you.

 

[pdx_man]

Need to set up a group in the report. Under the View menu, select Sorting and Grouping. In the popup window, select the field by using the dropdown. Below, in the properties, select Yes for group footer. In there, put =count([fieldname]) in the control source for an unbound text box. Do not specify which value to count, it will be picked up by the grouping function.