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

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.

jvbd02: How did you do it? I am in need of a solution to concatenate multiple Access reports into one via VBA.

If anyone out there knows, I'd greatly appreciate a code example.

Thanks,

Dave

You realize that that was 8 years ago

Start a new thread, please.