how to count unique records in a report?

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

i have a report that lists duplicative records. at the end
of report, i'd like to add the total number of "UNIQUE"
or "Distinctive" records as well as the total number of
records.

i can do the total number of records by using "=Count
([Fieldname])". how can i count 'unique' entries, however?
 
Forget about the report for a moment and create a query that selects unique
records. Save this query as qgrpMyUniqueRecords. Then add a text box to the
report footer with a control source of:
=DCount("*","qgrpMyUniqueRecords")
 
thanks much! it worked!!!
-----Original Message-----
Forget about the report for a moment and create a query that selects unique
records. Save this query as qgrpMyUniqueRecords. Then add a text box to the
report footer with a control source of:
=DCount("*","qgrpMyUniqueRecords")

--
Duane Hookom
MS Access MVP


i have a report that lists duplicative records. at the end
of report, i'd like to add the total number of "UNIQUE"
or "Distinctive" records as well as the total number of
records.

i can do the total number of records by using "=Count
([Fieldname])". how can i count 'unique' entries,
Click to expand...
however?


.
Click to expand...
 
Back
Top