"John W. Vinson" wrote in message
...

is an "unmatched query" which will find all records in the input file
which do
NOT have matching MyData. You can then manually correct the errors in
tblBadLookup and run another append query resembling the first one to
insert
them.



John - just spotted this after I posted my suggestion. Wasn't trying to
steal your thunder, sorry

Keith.