Counting in Reports

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
"IB_FCCJ" wrote in message
...
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

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" wrote:

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

Thanks Linda and Duane, I tried Duane's suggestion (a little simpler to
perform) and it worked perfectly.

"Duane Hookom" wrote:

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" wrote:

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