Using Records in a table as Criteria to loop

T

terry

I have a group of select queries in an Access 2002
database, each query needs to be run once for each
criteria, i.e. All 10 queries must run once
for "Aberdeen", then the same ten run again for "Glasgow"
and so on. Is there a way which this can be done in code
using the loop function, rather than having to have then
same set of queries for the number of criteria, or using
the [User Enter] function.
 
G

Guest

Terry, I am not sure that I understand your question but
in code you can open a recordset as a subset of the main
table and set just about any criteria using the WHERE
clause of the Open statement.

Does this help?

Robin
 

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
Changing query criteria through VBA 9
Creating Loop 3
Export query, changing one criteria multiple times, to Excel 4
Using a SQL Stored Procedure in Access 2
VBA: How can I use a string variable as autofilter criteria? 4
Use In() Expression as Query criteria with guts from Function 1
Append Passthrough Query Results to Local Table 2

Top