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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
search multiple criteria 0
Looking for Help With Access - Writing a criteria that crossreferences 2 tables 2
Multiple query criteria, results to new table 1
Finding the top categories in a query 6
sum based on criteria 1
Query Field Criteria 2
putting criteria in the table 4

Back
Top