98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Excluding some records
Excluding some records
Resolved · Low Priority · Version 2013
Tom has attended:
Access Intermediate course
Excluding some records
I have 2 database tables with a common field ([Reference Number]).
Table 1 has all of the reference numbers (in most cases multiple entries), whereas Table 2 only contains some of these and has only one entry in all cases.
I would like a query to show only those Reference Numbers from Table 1 that do not appear in Table 2.
Have just found the query I was looking for in the design wizard, didn't think of looking there first.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |