Allowing multiple Criteria in a Make Table macro

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.

"jesZee" wrote:

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.

Thanks Karl. I will check it out.

J


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

"jesZee" wrote:

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.