Need to counts of different values from one field in a report

[Guest]

I need to run a report that is bound to a table where some fields have
several different values. I need to put controls in the report that would
give me a total for each different value (eg. =count([ques], "doctor")) or
"nurse" or "assistant". Can this be done without a query?

 

[Duane Hookom]

Add a text box in a report or group header or footer with a control source
like:
=Sum( Abs([ques]="doctor") )

If you have more than a few values to check against and they may vary over
time, consider creating a subreport based on a totals query.

 

[PC Datasheet]

In your report, group on the field that gives you doctor, nurse or
assistant. Create a group Footer. Add a textbox to the group footer and put
this expression in the control source of the textbox:
=Count(*)
You will get three groups and the textbox for each group would give you the
total number of questions for the respective group.