Automating the input of query criteria

Posted by Steve Wren on Super User See other posts from Super User or by Steve Wren
Published on 2013-11-21T10:52:35Z Indexed on 2014/06/03 3:32 UTC
Read the original article Hit count: 232

Filed under:

microsoft-access-2010

New user to this site and found an extremely informative answer to a question I had but can't find an answer to this one.

Using Access 2010, I have 42 different criteria that I need to run individually using the same query. Rather than have 42 queries, or an input parameter dialogue box where I need to enter the criteria 42 times, can I automate this so that the 42 criteria are sourced sequentially from a different table and input to the query using a macro/ module etc. Unfortunately I have no experience of SQL/VBA so am struggling.

Any help would be greatly appreciated.

Related posts about microsoft-access-2010

Microsoft Access 2010 Tips and Tricks

as seen on ASP Free - Search for 'ASP Free'
Make Use of Templates If you are totally new to Access 2010 and are worried about starting your own database from scratch, don't worry, as Microsoft has loaded the program with tons of templates to help you get started. The templates range across different industries to cover varying needs, and you… >>> More
How to Create Forms in Microsoft Access 2010

as seen on ASP Free - Search for 'ASP Free'
This tutorial will teach you how to create a form from a table in Access 2010, as well as a few added tips on how to insert additional fields and a drop-down menu into the form. The tutorial is basic, but it does lay a foundation that will increase your productivity and make life easier when it comes… >>> More
Cannot write to registry while installing Microsoft Access 2010 - Error 1406

as seen on Super User - Search for 'Super User'
While installing I get an error: Microsoft Access 2010 encountered an error during setup. Error 1406. Setup cannot write the value to the registry key \Software\Classes\Interface{000C036F-0000-0000-C000-000000000046}\ProxyStubClsid. Verify that have sufficient permissions to access the… >>> More
When importing an Access table into Excel, a look-up column is showing all values as numbers

as seen on Super User - Search for 'Super User'
I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers can have the same name), and each row also has manager name, manager email, etc. The second data… >>> More
Automating the input of query criteria

as seen on Super User - Search for 'Super User'
New user to this site and found an extremely informative answer to a question I had but can't find an answer to this one. Using Access 2010, I have 42 different criteria that I need to run individually using the same query. Rather than have 42 queries, or an input parameter dialogue box where I need… >>> More

Developer IT