help with Count

[MJD1]

Hi all,

I'm working on a report that lists locations that are in exception. these locations have ratings such as L, M or H. Using Count([location]) on the report I was able to obtain the total number of records appearing on the report, but I can't figure out if theres an easy way of using the count method to determine the total number of records for each rating. for exemple, if theres a total of 12 locations, 4 that are L, 2 that are M and 6 that are H.

any help is appreciated.

martin

 

[PHV]

A starting point:
Sum(IIf([rating]='L'),1,0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MJD1]

Thanks, I forgot to mention that I am still using access97, will that make a difference?

 

[MJD1]

PHV, thanks for your guidance, I got it working.


Martin