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

the SUM function and rounding?

P: n/a
I have a field on a form using the sum function
[fedsrsubtotal]

made by this formula
= Sum([fedsr])

format is 0000.00

this 'sum' seems to leave out cents. by that I mean if I have 3 values
in ([fedsr])

1122.55
789.00
12.00

I do not see the .55 in the = Sum([fedsr]) IE 1923.55. What I see
instead is 1924.00

does the 'sum' round by default? I cannot find anything in the help
files for access.

jim

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.