no records from one query in other query

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

Guest

I have three queries that specify people who will receive a personalized
fundraiser letter. Is there an easy way to ask a query (generated for those
to receive a general newsletter) NOT to include these people?
 
Use a left join from the "general newsletter" query to the others.
Use criteria for the "personalized fundraiser" fields like --
<>[general newsletter].[TheID] Or Is Null

[TheID] is the field used in the join.
 
Thank you! I knew there was an easy way, but my brain was fried and couldn't
think of it.

KARL DEWEY said:
Use a left join from the "general newsletter" query to the others.
Use criteria for the "personalized fundraiser" fields like --
<>[general newsletter].[TheID] Or Is Null

[TheID] is the field used in the join.

sorrywm said:
I have three queries that specify people who will receive a personalized
fundraiser letter. Is there an easy way to ask a query (generated for those
to receive a general newsletter) NOT to include these people?
Click to expand...
Click to expand...
 
Back
Top