Claire,
The first thing that comes to mind is to build a mimic text box at the top
of your report that reflects the data in your totals at the bottom. You can
do this in the properties of the new text box at the top. I have done this in
forms and the code looks like this:
[forms]![NameOfYourForm]![NameOfTextField]
I would bet the syntax is pretty much the same for a report. Hope this helps.
Jacqueline
--
Jacqueline
"Claire" wrote:
[Quoted Text] > I have a report grouped by department, with each department totaled in the
> group footer, and the company total (grand total) in the report footer. All
> of this is working just as desired.
>
> However, I am trying to replicate a previous excel report (in formatting),
> which has the department totals and company total repeated at the top of the
> page. I could work with it in the report or page header. Is there a way to
> list the group totals in the page or report header or do I need to add a new
> calculated field and put in a conditional sum, depending on the departments?
>
> Thanks for your suggestions!
|