Query missing records

tezread

Registered User.
Local time
Today, 23:42
Joined
Jan 26, 2010
Messages
330
I have three tablestblPatienttblMINAPtblBCISI have set up an indeterminate relationship between tblPatient and tblMINAP using NHSNumber, and done the same with tblBCIS.My problem is thistblMINAP is a complete dataset for the financial 2010/11tblBCIS only has April 2010 to January 2010.How do I find out which records in tblBCIS are 'missing'The answer is on the tip of my brain....
 
I think I have a solution.. use the unmatched query?
 
Yep, that sounds like what you need...
 

Users who are viewing this thread

Back
Top Bottom