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

monthend

P: n/a
My database has a member whose annual dues are $2500.00 and he is billed
monthly. Each month he is billed 208.33333333333 which is formated standard
with 2 decimal places.If I run a statement for this member and have a running
sum, two months of billing will show 208.33 for each month but the running
total will show 416.67. I realize this is due to rounding but is there any
way to get the total to show the sum of the actual amounts of billing shown
on the statement which would be 416.66.

Dumb question but would like to know if there is a solution ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

May 21 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.