Office 97

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a Field called Agent that contains "none" and details other than none
I need to show in a report a Count of ""none" cases & a Count of the other
entries. It has to be this way because the maindata Table will be updated
monthly.

How can this be done?


Best Wishes
Bruce
( Illegitimi non carborundum est )
 
To count the number of records in a report where the field Agent contains
the value "none", you would use a text box in the report footer with a
control source of
=Sum( Abs([Agent]="none") )
You should be able to figure out the other value.
 
Back
Top