Marshall the report currently has 4 columns in it, the labels are being
hidden by code, so that I get something like this.
Lbl Data1 Data2 Data3 Data4
"" "" "" "" ""
THe columns are the length of the whole page. When I tried to group on -1
and ran the report it asked me for the value of -1(maybe I don't know what
you are asking me to do exactly) but it ran and did the following.
lbl Data1 Total Data2 Total Data3 Total Data4 Total. and
what I would like is
lbl Data1 Data2 Data3 Data4 Total
If it would help I could send you a copy of the DB and show you what it is
doing. Please let me know.
Marshall Barton said:
Not sure which "it" didn't work. If it was the idea of
using a group footer, then it sounds like you did not create
a new top level group using the expression =1.
--
Marsh
MVP [MS Access]
John said:
Marshall didn't really work, for one it put the totals for each group. I
guess I should have given you more information. I am using the group footer
to sum everything first, then I put the grand totals in the report footer. I
am not using the details section at all.