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
delete the duplications.
What should I type in the criteria?
Thanks
-
-
Re: duplicated items
If you start a new Access query, there is a built in Wizard to detect
duplicates.
Regards
Peter Russell
Jacky11 previously wrote:
[color=blue]
> 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
>[/color]
-
Re: duplicated items
> I would like to have a query of all duplicated items. I don't want to[color=blue]
> delete the duplications.
> What should I type in the criteria?[/color]
- 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.
Comment
Comment