I am trying to design a report that has four fields, city
(text field), building name(text field), building area
(number field), and leased or owned (logical field). I
have set up the report so that it is grouped by city and
then by leased or owned. I would like to keep a running
total of all the owned areas and leased areas separately
and then print the grand total for each at the end of the
report. I would also like to print the sum of the leased
areas and owned areas separately in the city group footer.
I tried DSUM but it doesn't appear to work. Anyone have a
suggestion.
Gerry
Marshall Barton - 08 Oct 2004 16:26 GMT
>I am trying to design a report that has four fields, city
>(text field), building name(text field), building area
[quoted text clipped - 7 lines]
>I tried DSUM but it doesn't appear to work. Anyone have a
>suggestion.
That's a little vague to get a specific response. In
general, you should explore using a text box with its
RunningSum property set to Over Group.
The City group footer and the report footer can display the
total area by using a text box with an expression like:
=Sum(IIf([leaseown], [area], 0))
and
=Sum(IIf(Not [leaseown], [area], 0))

Signature
Marsh
MVP [MS Access]