A footing in the report

[ericlee]

hello all,

i have a problem with a label/textbox in the footer of the reports.

i try to have a set of 3 copies of the report which is only different in the footer. i want the first one have "Shipping", the second one have "Finance" and the third one have "Sales" on the report. at the moment, i design three reports and print them out one by one as follows:

DoCmd.OpenReport "SDebitNote2", acViewNormal, "", pstrCriteria
DoCmd.OpenReport "SDebitNote3", acViewNormal, "", pstrCriteria
DoCmd.OpenReport "SDebitNote4", acViewNormal, "", pstrCriteria

i wonder if i can have only one report and pass the parameter "Shipping", "Finance" and "Sales" into the report.

thanks for your help in advance.

 

[gmit]

Can you not add the other reports as subreports. This would display all three on one report.