pleasehelpalot
Instructor
I have two tables; A & B. Table A has 130 records for location code 10. Table B has 91 records for location code 10. How do I produce a list of the records which are in table A but not B for location code 10.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to find the missing records?
- Thread starter pleasehelpalot
- Start date
- Status
Use the Find Unmatched Query Wizard.
If you have already tried this but it didn't work then you should state why it didn't work.
Duane
Hook'D on Access
MS Access MVP
If you have already tried this but it didn't work then you should state why it didn't work.
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #3
pleasehelpalot
Instructor
Actually i never heard of it. Is it on the menu?
- Thread starter
- #4
pleasehelpalot
Instructor
Oh, of course under queries. Sorry, I never use the wizards, but this one I need.
Thanks.
Thanks.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question