Samle flere rapporter i en

If you have a form where you enter the dates then you can alter the query which is used in the report to take the date values (criteria) from the form.

Th ecriteria will be something like

Forms!YourDateForm!DateFrom

and another for DateTo

This is actually what I am doing today.

The question is, how kan I run and assemble multiple reports in a singe click, so to speak.

I'd need a bit more information before I can suggest a solution.

Are the parameters different for each report? If not then you could maybe put the names of the reports in a table and then in code open a recordset on the table and loop through the records printing the report name you find and taking the parameters from the two date fields.

Hi Terry

I'll try again.

I have 4 reports, all which is based on input fromDate and toDate.

Today, I run the report one by one, passing 8 values into the report, and then I assemble them manually into one report. So far I can live with the pages numbers isn't in sequence.

What I am looking for, is how to merge these 4 reports into one, eg. by clicking a button the runs some VB code the runs the 4 reports and merge them into one final.

Is there any chance at all in seeing the dB? I'm a little confused as to how things are working now and what you finally want.

You say you have 4 reports but you run them one by one. And that you pass 8 values into THE report. THE report??

Do you mean that each of the 4 reports takes two values (fromDate and toDate)?

If so then the answer I gave 09/09-2008 12:26:14 should work.

if you can send the dB then I'll take a look later
ekspertenATsanthell.dk
AT = @