Retrieve DCount Statement (Duplicate Name) (1 Viewer)

[lhooker]

The below DCount statement gives me the number of duplicates records from the "Query_Find_Duplicates_For_Gift_Totals" query. How can I get the names of the
duplicate records from the below DCount statement?

DCount(" Gift_Totals.[Survey_Taker_Last_Name]", "Query_Find_Duplicates_For_Gift_Totals")

 

[pbaldy]

You can't get anything other than the count from the DCount(). Perhaps base a form/subform/report on the query?

 

[plog]

Presumably from the query itself. But....what's the big picture?

Once you have these names (which you already do), what are you going to do with them? What's the ultimate aim? With that we can help you get to where you want to be.

 

[ebs17]

The below DCount statement gives me the number of duplicates records from the "Query_Find_Duplicates_For_Gift_Totals" query

That's wrong. The DCOUNT simply counts the records in which the designated field has content, and it only returns a corresponding number.

For higher quality expectations, you have to formulate a query. Combination of two fields as a criterion for duplicate:

SELECT Key1, Key2, COUNT(*) AS Occurence
FROM TableX
GROUP BY Key1, Key2
HAVING COUNT(*) > 1