Round Up/Down 4 Decimals to 2

[newbie]

I am working in MS Access 2003. I have imported tables that have 12 digit text fields that look like this 000000012572. I have created a new text box on my report that has a control source of =Val([fieldname]) and a format of #\.0000 so that 000000012500 now displays as 1.2572. This is great for most of my fields except one. I need one of my fields to round the decimal to 2 places so that 1.2572 would be displayed as 1.26. Does anyone have any suggestions on how to do this? THANKS!

[weekend00]

can you use round(xxxx,2)?

[newbie]

No, I already tried that. I continue to receive 1.2572.

[weekend00]

can you show me how did you get 1.2572 from 0000012572?

[newbie]

I created a text box and in the control source I used Val([Field Name]) and on the format of the text box I used #\.0000. The Value expression removed all my leading zero's. The #\.0000 formated it so that that a decimal point was placed 4 digits in and that if the first number after the decimal is a zero it will still show.

[weekend00]

change the format to standard, and use =val[field]/10000 as control source

[newbie]

Brilliant! Thank you.