Hi all
This is driving me spare. I have been trying for hours, using all of the info in help and off the internet, to find records that are in one table but not the other, using the unmatched record query in Access.
I have two file both in exactly the same format like this:
Vehicle Record No.
Service Date
Invoice Number
Service Code
Service Details
Mileage
Value
event type id
All I want to do is compare the two file's records on every single field. I.e. if there is a record that is the same in both files, on every single field but just one of them differs, I want it to bring it across into a separate table. If the record matches on EVERY field then I'm not interested in it. Only the one file is going to have any of the records I'm interested in.
Any help, save me from insanity please!
Cheers
Mark
This is driving me spare. I have been trying for hours, using all of the info in help and off the internet, to find records that are in one table but not the other, using the unmatched record query in Access.
I have two file both in exactly the same format like this:
Vehicle Record No.
Service Date
Invoice Number
Service Code
Service Details
Mileage
Value
event type id
All I want to do is compare the two file's records on every single field. I.e. if there is a record that is the same in both files, on every single field but just one of them differs, I want it to bring it across into a separate table. If the record matches on EVERY field then I'm not interested in it. Only the one file is going to have any of the records I'm interested in.
Any help, save me from insanity please!
Cheers
Mark