Removing records using a query comparing two fields with identical values

[scottmfitzge]

Hi - I wonder if someone is able to help. I have two seperate fields in a query that I would like to 'compare'I would like to know if there is a way of being able to enter a 'condition' of somekind into the query to remove records, when the entry in each of the fields is the same.Thanks in advance for your help.Cheers, Scott

 

[Scooterbug]

Link the two tables by the field that you wish to compare. The query will then return only records where the fields match. From there you can delete them if you wish.

 

[scottmfitzge]

Excellent! Thanks very much for your help!Cheers, Scott