table validation

[jphillips]

Hello,

How can I select records from table 2 that are not in table 1 if the are some how related. I basically have some updated information from an orginal spread sheet I need to add to the database as new records.

 

[PHV]

Have a look at the unmatched query wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[alvechurchdata]

There's an example of how to do it by hand with a sub query on our site at

http://www.alvechurchdata.co.uk/accsubquery.htm

Geoff Franklin

http://www.alvechurchdata.co.uk