Printing a report using multiple sources

[Perry02]

Using Access 2000 VBA code, I want to print a report for each table created from a query (110 separate tables). All tables have an identical structure and the one report form will provide the uniform format that is required.

I know I could create 110 reports and then use a loop with the OpenReport method, but this report will be modifed periodically and I do not want to create or modify 110 reports. I have to believe that there is a VBA way of using one report form with 110 different record sources.

Any suggestions?

Thanks,
Perry02

 

[SkipVought]

Hi,

A "shoot from the hip" and uninformed reaction us...
Why have 110 separate virtually identical tables? Mebe a long term solution is to combine the data into ONE TABLE with a field to differentiate the subsets.

But, as far as a solution, try this,

Select a, b, c
From Table1
Where bla, bla bla
Union
Select a, b, c
From Table2
Where bla, bla bla
Union
...

ad 110 or infinitum, which ever come sooner

Hope this works


Skip,
SkipAndMary1017@mindspring.com