Finding Duplicates

[Lilbit]

I have different areas enter names they'd like to be included in a mailing.
Sometimes, there are duplicates. I've been trying to create a query that
finds them so I can have the creators of the lists decide among themselves
who should keep it on their list and get back to me how they've resolved
it. I haven't been successful. Someone told me to use:
SELECT [field1], [field2], [field3], count(1)
FROM [Your Table]
GROUP BY [field1], [field2], [field3]
HAVING count(1) > 1
However, when I go into Queries, New, I don't see Select, From, Group By,
and Having. Please help!! Thanks!!

 

[Jeff Boyce]

The New Object toolbar button includes a Query choice. If you select that
choice, you're given a list of potential query types, including a
"duplicates" query. The wizard will help you get started.

If you open the Query designer, you can select fields from tables, then turn
the query into a Totals query, with criteria -- this is the UI equivalent to
your SQL clauses.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Lilbit]

Thanks!!