Duplicate Records

D

Dimitris

Hello, In a database there are some duplicate records entered. I used the
querie wizard to find all the duplicate records of the table. I created a
field called "dupli" which is a checkbox. What I need is to have all the
duplicate records checked in the checkbox except one.

What I mean is that if "John Smith" is entered in the table 3 times I want
one "John Smith" unchecked and all the other ones (2 more in my example)
checked.

Can anyone help me?
Have in mind that I have used the fields "FirstName" "Lastname" and
"Address" to find the duplicate records. and I only used the querie duplicate
wizard, cause I don't know how to do it any other way.

Thanks
Dimitris
 
R

Ronx

You may wish to post this in a forum or newsgroup for the database being
used - I don't see any FrontPage problem in your question.
 

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

Delete all data after a symbol in a field 0
Check the duplicate records 1
Duplicate pst, or is it? 0
I have lost 6 months work, how can i get my file back 1
Delete duplicate records 3
Duplicate hashtags in OneNote 0
Is this possible? 0
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2

Top