Query design help requested

[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

 

[Allen Browne]

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.

 

[Victoria]

Yes, of course. Thank you.
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.

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

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



.