Find Duplicates data

[Fred's]

Hello all,

I have a table that have duplicates order numbers and now I will like
to made a query to tell how many unique order numbers I have, but my
problem is that if I do my query with the "Finds Duplicates Query
Wizard" the duplicate orders will be deleted from my table, and this
is someting that I must avoid.

Can somebody have any idea on how can I find the duplicate data
without deleting....

Any help will be welcome..

Thanking you in advance,
Fred's

 

[Tom Wickerath]

Hi Fred,

A Find Duplicates query is simply a SELECT query; it is not going to
automajically delete anything, unless you select a record and press the
Delete key.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________