excluding some records

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Excluding some records

Excluding some records

resolvedResolved · Low Priority · Version 2013

Edited on Wed 8 Jan 2014, 13:06

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Combo box for finding records

You 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

View all Access hints and tips


Server loaded in 0.08 secs.