Running sums

[Gerry Duggan]

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]

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.

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))