Hi, I am working on an application

[Reactorhead]

Hi, I am working on an application which I need to remove duplicate entry from a list of records.

I have two fields within a record that intially have the same value.
Field 1 : [123] = Field 2 : [123]

A change is made and Field 2 changes to 456. I now have the following records
Record 1 : [123] = [123]
Record 2 : [123] = [456]

How can I filter out record 1

Thanks in advanve if you can point me in the right direction.

 

[WildHare]

Do you mean how can you filter out records where the Values in FIELD1 and FIELD2 are alike? Easy. In query design grid, go to the CRITERIA cell either FIELD1 or FIELD2, and type

<> [FIELD2] < --- if you are in Field1, or

<> [FIELD1] < --- if you are in Field2


What you are saying is &quot;Give me only those recs where the value for FIELD1 is NOT EQUAL to the value in Field2.&quot;

You can probably deduce how the reverse logic could be applied as well.

The key is to surround the field names in the criteria cell with the Square Brackets.

J Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm