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

excluding some records

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

Excluding some records

ResolvedVersion 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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.