Duplicates

  • Thread starter Thread starter sally
  • Start date Start date
S

sally

Hi Everyone,

Does anydody know of a query that will highlight
duplicates, either in the output give records that are
duplicates, or display all data but with an added column
in the wuery results that "lablels" wich records are
duplicates.

I would be greatful for any ideas!
 
sally said:
Hi Everyone,

Does anydody know of a query that will highlight
duplicates, either in the output give records that are
duplicates, or display all data but with an added column
in the wuery results that "lablels" wich records are
duplicates.

I would be greatful for any ideas!
Click to expand...

There's a 'find duplicates query wizard' already built in. In the database
window, select 'queries' and then click 'new'.

Terry D.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Auto Matching Duplicates? 0
Excel Comparing two columns 1
Find Duplicates 1
Allow duplicates, but not for the same reference 5
Query to include the next but maximum record 4
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Access 2003 - Multiple matching records need to count as 1 occurre 2
How to stop duplicates in a query or report 3

Back
Top