Allowing multiple Criteria in a Make Table macro

J

jesZee

Hi Macro Genius,

I have a situation here. I have a make table query which I have to
change the "Criteria" field at least six times to make table with
different plants. I am trying to put it into a macro but I don't want
to have six of the same queries but with different criterias in it.

Can someone help me? I know a little bit of module - thought of using
that to have a pop-up form that asked me to put in the Plant but not
too sure how to approach that.

please advise.

Thanks in advance.

J.
 
K

KARL DEWEY

What about placing the criteria on separate rows in the query design view.
This set an OR function between each.
 
J

jesZee

Thanks Karl. I will check it out.

J


KARL said:
What about placing the criteria on separate rows in the query design view.
This set an OR function between each.
Click to expand...
 
Top