How to select using multiple criteria

[Ken L]

Ok, as suggested I redesigned my tables.

I have:
tblClient{ClientNumber, ClientName, ClientEmail}
tblEmailList{ListNumber, ListName}
tblClientEmailList{ClienNumber,ListNumber}

I need to be able to select multiple lists in the query. ie. List1, List2,
List7 and generate a list of clients email addresses that are part of those
lists. I have tried WHERE clauses that use AND's and OR's with the expected
results.

Is there a way for the query to stop for user input and then choose the
appropriate lists based on that input?

thanks

 

[[MVP] S.Clark]

In the EmailList table, add a checkbox. Use it as the Current lists to
send.

Then, in your query add criteria to only email those lists which have the
checkbox set to true.

You can create a form for this, of which the user enters the criteria prior
to executing the query, but I don't recommend, in this case, prompting
mid-query for the information.

FWIW, have you seen Total Access Emailer?
http://www.fmsinc.com/products/emailer/index.asp