how to count unique records in a report?

[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?

 

[Duane Hookom]

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")

 

[kim]

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,

however?


.