Worked great. Never thought you could combine a DELETE and SELECT together like that. Thanks.
Go Red Wings ..
>>I have two tables. I need to find and eliminate records in table 2, that are in table 1 using two variables, field 1 and field 2. Any ideas how to do this?
>>
>>thanks
>
>Assuming both fields are character data type and the same in both tables:
>
>delete from Table2 where Field1+Field2 in (select Field1+Field2 from Table1)
>
>Otherwise, you will have to Transform() [or convert] them to character strings. You should also test this on copies of your tables with a subset of the data. It worked for me when I tested it.
Some days it's not worth chewing through the leather straps ...