Calculate total records

[Craig]

Hi all,

How can I get an accurate number of clients served when
the report is grouped not by client ID but by product ID?

I've been trying to figure a control that will use an sql
statement or a dcount function but they are beyond me.

Any wisdom would be appeciated.

Thanks

Craig

 

[Larry Linson]

Use the DCount domain aggregate function, running a Totals Query or a Unique
Values query, rather than directly on the Table. See Help for details on
DCount.

Larry Linson
Microsoft Access MVP

 

[Kelvin]

A quick and dirty way is to create a query to do the count then add this
field to the record source for the report.

Kelvin