Adding .0 to numbers without a decimal in access query

Question

I need to be able to add .0 to integer numbers in access query. Please see example below

Current Table

61
61.5
68.0
70
72.5
84

What I would like the table to look like

61.0
61.5
68.0
70.0
72.5
84.0

The format of the field is text and would have to stay that way unfortunately due to a submission procedure we have to follow.

Any ideas are greatly appreciated.

Answer 1

You talk of a query but you do not mention much detail about it. As long as the column you are formating is a numeric data type only, then you can use:

SELECT Format([columnName], "0.0") FROM tableName);