Allowing multiple Criteria in a Make Table macro

  • Thread starter Thread starter jesZee
  • Start date Start date
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.
 
What about placing the criteria on separate rows in the query design view.
This set an OR function between each.
 
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...
 
Back
Top