Hi,

I have got a database which is creating x tables (with values) for y variables by running a vba code in which I have included a loop.
What I would like to do now is creating y reports via vba and via the same type of loop.

Each report will have to use data from several tables.

Is this possible and how do I start?

Many thanks,

Gurkie

what is X & y ? give me some examples...
and i tell we cont do any modification in the report


bye
------------------------
pap...

What are you creating so many tables? You probably do not need to do this. If all the tables are identical except for name, then you definently should be puting all the dat into a single table with a field that identifies the data, like "category". Then you will need a single report and just pick the "category" you want to print.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com