Find Missing Records in a table

  • Thread starter Thread starter Bob
  • Start date Start date
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
 

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

Add One Condition! 3
Delete Button Code needed ! 7
Using a Check Box as a Condition 4
Create a new Table Question 10
Adding True/False condition to my code 2
Can This be Done! 10
Getting a report to Filter 5
Continuous Form Question 5

Back
Top