reports with access

[Michael Kellermann]

Hello everybody,

i've got a problem with the designing reports. In my reports i use
grouping and sorting to get group headers and footers like this:

grouphead1
grouphead2
grouphead3.1
groupfoot3.1
grouphead3.2
groupfoot3.2
groupfoot2
groupfoot1

Now i want to calculate sums of every field in grouphead3.1 and
groupfield3.2 and print them in groupfoot2 like this:

groupfoot2
sum of fields in grouphead3.1
sum of fields in grouphead3.2

The problem here is that when access reachens groupfoot2 only the values
of grouphead3.2 are present. I don't find a way to calculate the sums
of grouphead3.1

So what can i do?

Regards
Michael

 

[Tom Wickerath]

Try summing the values in groupfoot3.1. You can set the visible property for this textbox
to No. This way it won't show up in this section. Then add a textbox to groupfoot2, and
set its ControlSource equal to the name of the hidden control in groupfoot3.1.

Control Source: = Name of Textbox in Groupfoot 3.1

Tom
______________________________________


Hello everybody,

i've got a problem with the designing reports. In my reports i use
grouping and sorting to get group headers and footers like this:

grouphead1
grouphead2
grouphead3.1
groupfoot3.1
grouphead3.2
groupfoot3.2
groupfoot2
groupfoot1

Now i want to calculate sums of every field in grouphead3.1 and
groupfield3.2 and print them in groupfoot2 like this:

groupfoot2
sum of fields in grouphead3.1
sum of fields in grouphead3.2

The problem here is that when access reachens groupfoot2 only the values
of grouphead3.2 are present. I don't find a way to calculate the sums
of grouphead3.1

So what can i do?

Regards
Michael