Calculate total records

  • Thread starter Thread starter Craig
  • Start date Start date
C

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
 
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
 
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
 
Back
Top