Query Problems

[Humanski]

This is a follow on to the Duplicate Query problem I did what was suggested and now I get this msg The changes you requested were not sucessful, they would create duplicate values in Index,Primary key or relationship, change data in fields. Is there maybe a way to write it in VB by saying if Invoice number is = to invoice number and the Date is different then delete one of the two records. This sounds so simple but I cant do it.

Can anyone help

E.g

In_no wt ref no date
123 23 1234 12/03/01
123 23 1234 13/03/01

I would like to delete the 13/03/01 as this is a duplicate with the wrong date I have this in 16000 records

Pawel

 

[cogent1]

It's not easy to help you, since we don't know the details. It sounds as if you need to run an update query on some of your records, rather than an append query. Can you be more explicit please.

 

[glynch]

If you ran an append query into a new table as Pat Hartman suggested, he told you that you would get a duplicate records error message, but go ahead and click OK and you would end up with only the records you wanted, with the dupes eliminated.

Is this what you did?

If you set up your new table properly it should be okay.

One more thing, this post should have been in the same thread as your previous post, then cogent1 and others would understand your problem and the history of it.