Criteria from Form

[Guest]

I am trying to run a series of queries where the criteria changes each time
the query is run on several fields. I created a form where I can enter the
criteria one time into text boxes on the form and let the queries look to the
form for the criteria.

My problem is in one field I have 2 things to look for that change each time:
#1: Not Like "A*" And Like [fieldname]
and
#2: Not Like "A*" And Not Like [fieldname]

I can make it work one way or the other, but not both without changing the
"Like" to "Not Like" in design view of the queries. Is there a way to do
this from a form?

Thanks!!
Susan

 

[Guest]

hi,
if you have 2 criterias then you will need 2 queries.
you did not supply enough info to go further on this.
in your code, you will have to set up an if then or select
case to determine which query is apporprate to run.