I have a report that I have grouped by account number. Each acct# has multiple fees and I only want the sum of the fees for each acct#. I have pulled the sum of the fees for each acct# into the group footer. Now I need to get a Grand Total of all those sums. I have written the calculation to pull this Grand Total, but because part of the calculation is a percentage, it is causing my end amount to be rounded up by $0.01. I tried adjusting the # of decimals, I've tried the TRUNC, ROUND, & ROUNDDOWN funcs and am not having any luck. Please help
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access - Grand Totals in a Report
- Thread starter kooley
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question