Round up this calculation

[burrina]

I need to make this calculation roundup to the nearest whole number. Example;
=([SumTotal1]-[Text491]) ' this equals $66.71 and it should show $66.72 the format is Currency

[June7]

Google: Access VBA round up function

Review
http://p2p.wrox.com/access/33483-roundup-function.html
http://www.vbaexpress.com/kb/getarticle.php?kb_id=424

[burrina]

I looked up the links you gave, Thanks. Still unsure if I have correct calculation or not.

=Int([SumTotal1]-[Text491])+1 ' equals $67.00
=([SumTotal1]-[Text491]) ' equals $66.7125 ' this shows up in my total as $67.71

Actual Amount should be $67.72 I think ? Which one is correct? If I use windows calc, $67.72 is correct using standard and basic

[June7]

What do you want? An integer (whole number) or two decimal places?

Neither of those expressions show using function for two decimal places demonstrated in the first link.

Probably showing as 67.71 in textbox because of format settings, however, the value is still 66.7125.

[burrina]

Thanks, I believe I have it fixed. Bigger fish to fry.Database is wrecked because of me implementing suggestions. Need to find something to drink!