On Open Event - Help Please

[Bill]

Hello, I would like to delete duplicates in my
table on the open event of a form
The table name is tblContacts and the fields
that will contain duplicated information
are AltTel (Could be the same as MainTel) and
AltEmail (Could Be the same as Email)

Is this something that I can achieve in Access2000 ?

Thanks


Bill

 

[Jeff Boyce]

Bill

It isn't clear, from your description, whether you are trying to delete a
field within a row when it duplicates another field in that same row, or if
you are trying to delete an entire row if it has a matching value in another
row.

And it would help if you could describe (outline) your table structure a bit
more...

 

[Bill]

Sorry Jeff

What I'm trying to do is to delete records in the
same table on the same the rows with duplicate
data.
This occurs when we import the Sales data from ACT
into the contact database for a mail merge, frequently
the users duplicate details.Sometimes it's not possible
to get a clean de-dupe because the address fields
or contact names are different, Mr J Smith - J Smith
but the e mail and phone numbers are consistent and
usually correct


Any suggestions would be welcomed

Bill

 

[Marc]

Hi
In Access go to the query window. Click on 'new query'. Click on the 'find
duplicates query'. Follow the directions.

HTH
Marc

 

[Bill]

Thanks Marc,but not what I'm looking for.

All I want to do is to blank a duplicated field entry
in the same row of a table ie Email1 (e-mail address removed) =
Email2 (e-mail address removed)

Any suggestions gratefully received


Bill

 

[Marc]

Ok then,
New Query,
Add Table Sales
Add Email2 in column 1
Add =Email1 in criteria for column 1
Run - does it return the correct records?
If it is wrong refine criteria - for instance =Email1 AND Len(Email1) > 0
If it is correct - change to an update query
It will show the update value field for Email2

HTH
Marc

 

[Bill]

Thanks Marc

I managed it with an update query following your idea of
Email1 AND Len(Email1) > 0

Many thanks again

Bill