Reports

[Frank Murren]

I am using Office XP and have a database which contains 5 reports.
Each report is run off a seperate query and each report also contains a
calculated sum which totals a Financial amount within the report.
Can anyone tell me if there is a way to automatically add the 5 individual
calculated report amounts and add them together to produce an overall
amount.
Thanks to any reply

--
Frank

[Con Giacomini]

Re: Reports

You can accomplish that by starting with an unbound report, then adding the
five existing reports as subreports. The final total can be expressed by:
=[1st report name].[total field]+[2nd report name].[total field] etc, etc.

"Frank Murren" <frank@cm-p.fsnet.co.uk> wrote in message
news:bvm926$l9q $1@news6.svr.po l.co.uk...[color=blue]
> I am using Office XP and have a database which contains 5 reports.
> Each report is run off a seperate query and each report also contains a
> calculated sum which totals a Financial amount within the report.
> Can anyone tell me if there is a way to automatically add the 5 individual
> calculated report amounts and add them together to produce an overall
> amount.
> Thanks to any reply
>
> --
> Frank
>
>[/color]