Duplicate Records (Display On Form)/No Duplicate Records (Display Single Record On Report) (1 Viewer)

[lhooker]

Is it possible to retrieve the count of duplicate records (produced from the query below) ? I want to see if there are any duplicate records, if so, then show them on a form. If no duplicate records, then display a report with the single record.

In (SELECT [First_Name] FROM [Location_Totals] As Tmp
GROUP BY [First_Name],[Middle_Name],[Last_Name],
[Attending_Location] HAVING Count(*)>1
And [Middle_Name] = [Location_Totals].[Middle_Name]
And [Last_Name] = [Location_Totals].[Last_Name]
And [Attending_Location] = [Location_Totals].[Attending_Location])

 

[arnelgp]

why do you need to find out whether there are duplicates when either way you will show the record/s anyway.

 

[lhooker]

To determine which process to take. By the way, both results will be on forms.

 

[Gasman]

Won't you just get dupes if they exist and nothing if they do not, with that query?

 

[lhooker]

Yes, but how can I determine this from a query called by a form button or VBA ?

 

[Gasman]

Do a DCount() on that query?

 

[lhooker]

That gave me the count. Thanks ! ! !