Printing field Values with 2 Decimal points

N

NJ

I have two number fields in my Access 200 table; FieldA, FieldB
Let say the value of FieldA is 275.01 and the value in FieldB = FieldA/17.55
How do I print both fields to print with 2 decimal places (178.36)?

Thanks
 
O

OfficeDev18 via AccessMonster.com

=Format(FieldX,"##0.00")

Be careful, though, as "##0" allows for maximum 3 places. Only 1 place is
required, however, and if FieldA is <1 it will show up as 0.XX (2-place
decimal). If FieldA can be 10 places, for example, use 9 "#" marks and the 0,
as in "#########0.00". See the Format() function for details and be sure to
read the examples.

Hope this helps,

Sam
 
N

NJ

Thanks, it worked.

OfficeDev18 via AccessMonster.com said:
=Format(FieldX,"##0.00")

Be careful, though, as "##0" allows for maximum 3 places. Only 1 place is
required, however, and if FieldA is <1 it will show up as 0.XX (2-place
decimal). If FieldA can be 10 places, for example, use 9 "#" marks and the 0,
as in "#########0.00". See the Format() function for details and be sure to
read the examples.

Hope this helps,

Sam
Click to expand...
 
O

OfficeDev18 via AccessMonster.com

You are right, Jamie,

and thanks for teaching me something today.

Sam
 
Top