Please Help!? Running Totals on Reports

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

Guest

I would like to see a count of the total number of records produced on my
report. I need to use the value entered in the dialog box for the query to do
this but it doesn't seem to be working!
I already have the basic structure of the count, but I must be missing
something, please help! Heres what I have.

=IIf([Work Station]="Query![frmWork_Allocation_Work_Station]![Work
Station]",1,0)
 
I would like to see a count of the total number of records produced on my
report. I need to use the value entered in the dialog box for the query to do
this but it doesn't seem to be working!
I already have the basic structure of the count, but I must be missing
something, please help! Heres what I have.

=IIf([Work Station]="Query![frmWork_Allocation_Work_Station]![Work
Station]",1,0)
Click to expand...

I have no idea what you are attempting to do here, but to get a count
of records in your report, use an unbound control:
=Count(*)
in the report detail section or report header or report footer.

The same expression in a group header/footer will return the count of
that group only.
 
Back
Top