468,247 Members | 1,323 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,247 developers. It's quick & easy.

duplicated items

I would like to have a query of all duplicated items. I don't want to
delete the duplications.
What should I type in the criteria?

Thanks
Nov 12 '05 #1
2 1211
If you start a new Access query, there is a built in Wizard to detect
duplicates.

Regards

Peter Russell

Jacky11 previously wrote:
I would like to have a query of all duplicated items. I don't want to
delete the duplications.
What should I type in the criteria?

Thanks


Nov 12 '05 #2
> I would like to have a query of all duplicated items. I don't want to
delete the duplications.
What should I type in the criteria?


- Create a new query.
- In the first window, select "Find duplicates query".
- Follow the wizard.

If you don't have it installed, you'll find it in the setup program under
'additional wizards'.

Peter
--
No mails please.
This posting is provided AS IS with no warranties, and confers no rights.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sachin | last post: by
10 posts views Thread by WT | last post: by
4 posts views Thread by Tony WONG | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.