Counting Grouped Records 1

[CharlieT302]

I have a report that shows clients by provider:

Provider1
Client # Active Remote
Bob Yes No
Sally No Yes
Mary No No

The Active and Remote fields are "Yes/No" fields. I wish to count the number of "Yes" entries only.

I have a calcualtion in the "Provider" group footer. I I use "Count" it counts all entries. If I use Dcount, it counts the "Yes" values for all providers in the "Underlying query," rather than just the records displayed for the current provider.

Help is appreciated

 

[PHV]

Try Abs(Sum())

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

 

[CharlieT302]

That appears to have done it! Thanks much.