no records from one query in other query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sorrywm - 03 Nov 2005 22:31 GMT

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?

Reply to this Message

KARL DEWEY - 03 Nov 2005 23:34 GMT

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.

> 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?

Reply to this Message

sorrywm - 04 Nov 2005 00:09 GMT

Thank you! I knew there was an easy way, but my brain was fried and couldn't
think of it.

> Use a left join from the "general newsletter" query to the others.
> Use criteria for the "personalized fundraiser" fields like --
[quoted text clipped - 5 lines]
> > fundraiser letter. Is there an easy way to ask a query (generated for those
> > to receive a general newsletter) NOT to include these people?

Reply to this Message