By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Access 2003

P: 16
I have created a graph in ms access report in need to insert 2 grand total columns and sum them if i do this in design view on the data sheet it shows but if i change it to layout view it does not show the changes how do i refresh so it shows the changes

Thanks

Dave
Sep 10 '07 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
Grand totals are usually calculated in unbound text boxes in the footer section of a report. This works independently of landscape/portrait view...

Regards,
Scott
Sep 10 '07 #2

P: 16
Hey Scott can you explain to me how to do the below Procedure
I need to get these grand totals on to the graph


Grand totals are usually calculated in unbound text boxes in the footer section of a report. This works independently of landscape/portrait view...

Regards,
Scott
Sep 11 '07 #3

Scott Price
Expert 100+
P: 1,384
Hey Scott can you explain to me how to do the below Procedure
I need to get these grand totals on to the graph
I'm not sure about getting them on the graph itself, unless you want to get into PivotTable/PivotChart views (on which I am not an expert at all... )


The chart/graph object is your visual representation. However the method I was thinking of is to include an unbound textbox in the footer of your main report. To do this, enter something like this in your text box:
Expand|Select|Wrap|Line Numbers
  1. =DSum("[Quantity]*[UnitPrice]", "Order Details", "[ProductID] = " _
  2.     & [ProductID])
This code will have to be changed to fit the actual data you are working with, but should be what you need in calculating your totals.

Regards,
Scott
Sep 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.