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

how to find grand total in access report for a field with expression

P: 66
In the Report 1 of the fields contain expression.When i m trying to find the grandtotal for this field it gives me error..

For ex- The field expression is Format([GstPercentage],"0.00") to limit the field value upto 2 decimal but with this expression i can't find the grandtotal.So wanted to know how can i find grand total for this field.
Dec 11 '09 #1
Share this Question
Share on Google+
6 Replies

Expert 100+
P: 636

Don't format the field in the query, set the formatting of the report's control (Textbox?) that displays the result(s). You should then be able the get the totals and any sub-totals and then format them also.


Dec 11 '09 #2

Expert 5K+
P: 8,703
  1. Place a Text Box in the Report's Footer Section and set its Control Source as such:
    Expand|Select|Wrap|Line Numbers
    1. =Sum([GstPercentage])
  2. Set the Format Property of the Text Box to whatever you like.
Dec 11 '09 #3

P: 66
Problem here is that if i do it in this way as =Sum([GstPercentage]) in the Report's Footer Section ,the grandtotal appears as 65.095 in Access which is may b a rounded value(may b it takes 4 decimal places)....but when i export this report to excel my total is 65.093....shows ad difference of 0.002

So how to limit the decimal places in Access itself so that the grandtotal is same as that of excel...
Dec 12 '09 #4

Expert 5K+
P: 8,703
Expand|Select|Wrap|Line Numbers
  1. =FormatNumber(Sum([GstPercentage]),2)
Dec 12 '09 #5

P: 66
Sorry!!I tried it out but not working still
Dec 12 '09 #6

Expert 5K+
P: 8,703
Can you Attach the Database or a Subset of it?
Dec 12 '09 #7

Post your reply

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