How do I 'concatenate' snapshot reports (Access VBA)

[jvbd02]

Hi,

I have a number of access databases which I loop through, run the same query on, and end up with a snapshot of each.

I am looking to 'concatenate' or similar these snapshots so that they can be displayed in just one report. How can I do this?

Alternatively, can I run this query on each of these databases and continually write the report info to a single snapshot file until all databases are looped through? If so, how do I do this?

Thanks.

EDITED: Never mind - I have changed the design so that I do not have to deal with report snapshots anymore.