Decimal Places

[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?

 

[fredg]

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?

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