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 / December 2005

Tip: Looking for answers? Try searching our database.

Complicated summing in a report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jon Rowlan - 01 Dec 2005 09:07 GMT
I have a crosstab table that produces Sales Stats for each customer over a
number of years listing the sales for each period across the page.

This works very well and I can produce totals at the bottom of the report.

However, the customer wants to see totals in much the same way as they are
printed for each customer, one grand total for each year for each month.

customer ABC

           Jan        Feb        Mar        Apr
2001        10        20        10        40
2002        15        16        20        16
2003        16        17        10        20

Customer
Totals        99        99        99        99

Grand Totals

2001        999        999    999        999
2002        999        999     999        999
2003        999        999      999        999

Is this possible? Perhaps with "Running Sum" ?

To me it seems an unreasonable request .... should really be a different
report ....

Any ideas anyone ?

thanks all,

jON
John Spencer - 01 Dec 2005 13:29 GMT
You are correct, it is a different report.

Build it as a different report and then use your summary report as a
SUB-report in the report footer (or some other group section) in your
original report.

>I have a crosstab table that produces Sales Stats for each customer over a
>number of years listing the sales for each period across the page.
[quoted text clipped - 30 lines]
>
> jON
Jon Rowlan - 01 Dec 2005 15:11 GMT
perfect Thanks John.

I will give it a go.

jON

> You are correct, it is a different report.
>
[quoted text clipped - 38 lines]
>>
>> jON
 
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.