Query design help requested

  • Thread starter Thread starter Victoria
  • Start date Start date
V

Victoria

hello to all

I'm fairly new at this! Here's my situation. qryA and qry B have identical
structures. The PKey used in both is EmplID.

I need to know how to construct qryC (again with the same fields) so that it
contains ALL the data rows in qryA EXCEPT those also in qryB.

Help greatly appreciated
Victoria
 
Use the unmatched query wizard (first dialog when you create a new query.)

Use qryA as the first 'table', and qryB as the one to exclude.
 
Yes, of course. Thank you.
Victoria

Allen Browne said:
Use the unmatched query wizard (first dialog when you create a new query.)

Use qryA as the first 'table', and qryB as the one to exclude.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.



.
Click to expand...
 
Back
Top