Counting in Reports

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

Guest

One field in my database contains 4 default identifiers that tell me which of
our 4 staff is assigned to handle that particular file. How do I auto-count
the number of occurrences of each identifier in a report footer? or How do I
auto-count the number of files assigned to each person through this feature?

ie record #02040 is assigned to IB
record #02050 is assigned to IB
Total records assigned to IB - 2
 
I'm sure there are more sophisticated ways to do this, but the way I have
done it in the past is to add a field to my query which I call CountMe and
give it a constant value of 1.

In the footer for your group section, create a text box and give it a value
of =Sum([CountMe]).

Linda
 
The best method is to use a totals query as the record source of a subreport.
Then when you add another staff member you don't have to do any more work.
However, you can add expressions in group and report headers/footers like
=Sum( Abs([YourField]="IB") )
 
Thanks Linda and Duane, I tried Duane's suggestion (a little simpler to
perform) and it worked perfectly.

Duane Hookom said:
The best method is to use a totals query as the record source of a subreport.
Then when you add another staff member you don't have to do any more work.
However, you can add expressions in group and report headers/footers like
=Sum( Abs([YourField]="IB") )
--
Duane Hookom
Microsoft Access MVP


IB_FCCJ said:
One field in my database contains 4 default identifiers that tell me which of
our 4 staff is assigned to handle that particular file. How do I auto-count
the number of occurrences of each identifier in a report footer? or How do I
auto-count the number of files assigned to each person through this feature?

ie record #02040 is assigned to IB
record #02050 is assigned to IB
Total records assigned to IB - 2
Click to expand...
Click to expand...
 
Back
Top