Automating parameter passing to a query

A

Aditya Lele

Hi,

I am a beginner user of Access. I know how to make simple queries and
reports. How do I make my report run the query on a set of variables. Could
I have my values in a table and make my query read one value and process it
at a time, do it for the next value and so on. Let me know what I should be
reading to get a hold on this. Appreciate your help.

Thanks,
Aditya
 
M

[MVP] S.Clark

This can probably be done with a subquery. I don't know your exact
situation, but they look like the following:

Select * from (Select field from SameOrOtherTablename)
Select * from tablename where fieldname = (Select field from
SameOrOtherTablename)
 
A

Aditya Lele

I am interested in generating a report based on certain table. The query that
I have cuurrently runs on one record of the table (made a parameter query). I
want this query to be run again and again on probably the entire set of
records in the table. How do I automate running this query in a loop ?
 
Top