Hello,
I would like to create a query that will delete records that match several fields from another table. This is complicated by the fact that one of the fields will be in one of 3 columns.
I have attached a test database (no real details), all Sheet2 entries need to be deleted from Sheet1.
What I need to do is delete records that have the same 'Surname' and 'DPS' value but also the same 'Line5' value from Sheet2 in 'Line3' or 'Line4' or 'Line5' in Sheet1.
The 'Surname' and 'DPS' are no problem, it's the variable position of the third field that I really need help with. I think I could do it in three seperate queries but it would definitely be better in one.
Thanks in advance for any help,
James.