>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.
Mark McCasland
Midlothian, TX USA