Deleting records

[Viktor via AccessMonster.com]

Hi people, here yet another question about deleting records in a table...

I have a table A with three fields: A_id, A_value1, A_value2. The value
fields might have the same data...
The table would look like similar to the following:
01 six green
02 four yellow
03 two black
04 one yellow
05 nine green
06 four yellow
07 four black
08 five green

How do I delete only those records that have the exact same data in both
value columns (four yellow in this case). To clear it a bit, I'd like to
keep only one record if I have 2 or more records that have same data in the
columns.

Thanks in advance,
Viktor

 

[Guest]

Use the find duplicates query wizard to create a query that finds duplicate
records in a table. Then use the query created by the wizard as the basis
for a delete query.

 

[Viktor via AccessMonster.com]

Thanks, I somehow managed to do it like you suggested... Although it took me
some time to get the results i wanted... Hopefully I will get better at this :
)