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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.