Decimal Places

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

i have a number field with figures like 1.1, 2.25, 3.4, 3.45.

i'm just trying to format the number within a query to show 2 decimal places
no matter what.

for example:

1.1 would be 1.10
3.4 would be 3.40

any ideas?
 
i have a number field with figures like 1.1, 2.25, 3.4, 3.45.

i'm just trying to format the number within a query to show 2 decimal places
no matter what.

for example:

1.1 would be 1.10
3.4 would be 3.40

any ideas?
Click to expand...

In a query:
ColumnName:Format([FieldName],"#.00")
 
Back
Top