Returning records NOT in a table

  • Thread starter Thread starter Rodtnick
  • Start date Start date
R

Rodtnick

I have a programing data base that is has two tables (Programs and Used)
linked at ProgramID. When I schedule a program for air the date of that
program is added into the Used table. I want to choose all the programs
that have not been used, in other words do not have an entry into the
Used table. How can I do that?

Bruce Rodtnick
 
There is an Unmatched Query Wizard to do this for you.

In essence, it is an outer join where Used.ProgramID is null.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query is not locating all records 3
Query on a subform 1
Help - Another hard query 3
How to export table from outlook into ms access table? 0
Dcount returning no results!!! 0
Split data in field on character return 0
Program and Student Enrollment 3
Have both records from two queries/tables under one Query without related fields. 0

Back
Top