Omittiing Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to tables.

I want to create a query which will show the records of table A, but if any
of these records appear in table B, i want them to be omitted!

Can this be done?


Thanks
 
Open a new query in design view

Show the two tables

Select the primary key and foreign key fields and put them into the bottom
pane (I assume it is a one-to-many relationship).

In the foreign key field criteria row type "is null"
 
I have to tables.

I want to create a query which will show the records of table A, but if any
of these records appear in table B, i want them to be omitted!

Can this be done?
Click to expand...

The "Unmatched Query Wizard" will do this for you. Equivalently, follow
scubadiver's advice with one addition: select the Join line between the two
tables and choose Option 2 - "show all records in TableA and matching records
in TableB".

John W. Vinson [MVP]
 
Yeah, cheers!

--
www.ae911truth.org



John W. Vinson said:
The "Unmatched Query Wizard" will do this for you. Equivalently, follow
scubadiver's advice with one addition: select the Join line between the two
tables and choose Option 2 - "show all records in TableA and matching records
in TableB".

John W. Vinson [MVP]
Click to expand...
 
Back
Top