Office 97

[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 )

 

[Duane Hookom]

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.