459,677 Members | 1,188 Online
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
6 Replies

 Expert 100+ P: 636 Hi 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. HTH MTB Dec 11 '09 #2

 Expert 5K+ P: 8,703 Place a Text Box in the Report's Footer Section and set its Control Source as such: Expand|Select|Wrap|Line Numbers =Sum([GstPercentage]) 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 Try: Expand|Select|Wrap|Line Numbers =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