Using Access 2003, I have database with a one field table, tblID, with a
series of 3 digit code numbers. Field name is CtxNum. These numbers came
from a mainframe download, imported into Access from a text file.
Another table, tblProvider, has 11 fields, one of which is the code number,
and the field name is likewise CtxNum. I need to delete all records from the
tblProvider where the value in CtxNum doesnt match up with a value in tblID.
I am stumped.
Thanks for any help.