Find Missing Records in a table

B

Bob

2 of my tables:
tblHorseInfo, feild: HorseID
tblHorseDetails, field: HorseID
But if their is no OwnerID assigned to HorseID , tblHorseDetails will not
show that horse unless it has a OwnerID but it does in show HorseID in
tblHorseInfo
how can I make a query to show the HorseID in tblHorseInfo that is not in
tblHorseDetails
Thanks Bob
 
B

Bob

Ok Im Stupid ;) Query: Find Unmatched Query Wizard
It even does it for you duuur....Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Expression Help! 26
4 #Error Lines in a Query 2
Query to show Not Unique 11
Stop some records sending table! 0
Using a Check Box as a Condition 4
New sequentiall Number to new record 19
Delete Button Code needed ! 7
Ok This one is Tuff 3

Top