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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
Back
Top