Creating a simple loop.

[Robert Picart]

I would like to create a simple loop within Access.
Here's what I want to do:

1. Using one report
2. Be able to submit a list of names to a query (eg.
Customer)
3. Have Access generate the same report (possible export)
using a different customer in the list each time until the
list is complete and then stop.

Help please.

 

[Andrew Coyle]

Hi
Can we just clarify something before addressing your problem directly:

Are you aware that if you base your report on a table/query it will produce
(can make export if you want) the report for each one of the records in the
table/query.
eg if you have a query which returns 10 records, Access will generate 10
reports automatically (1 for each record).
So assuming you can get a table/query with all the records you want you
should be able to get each of the reports by default.

Assuming that you know that and this is not your problem, is your problem
how to generate the query dynamically ie how to add specific customers into
the query? (possibly using a loop)

If you could be a bit more specific then we can target your problem better.

regards
A