Roundup in Control Source

[handlebarry]

hi - In a text box I have a currency amount of 46.324

The control source for this box is =([unit_total]*0.1)

This logically rounds to £46.32 but I need £46.33, I've tried =roundup(([unit_total]*0.1),2) but I just get #Name (maybe because this is a worksheet function)

can anyone help?

 

[smandoli9]

Try switching to Euros?

ONLY JOKING. This link may be useful:

http://www.mvps.org/access/modules/mdl0054.htm

[purple]_______________________________
_{Never confuse movement with action -- E. Hemingway} [/purple]

 

[handlebarry]

thanks smandoli - will take a look

p.s. we'll "think" about switching to the Euro if you give us our rebate ;o)