Using Records in a table as Criteria to loop

  • Thread starter Thread starter terry
  • Start date Start date
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.
 
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
 
Back
Top