Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Running sums

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gerry Duggan - 07 Oct 2004 17:48 GMT
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]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.