Format Number

[DBFIN]

How can a reformat a number from 23 to 23.00 in a query. The format functions reformats it correctly but converts the number to text. I need to format the number as 23.00 and maintain the value as a number, not as a text. How can I do this ?

 

[Minty]

In the query design window right click the column select properties and set the decimal to 2

 

[DBFIN]

I did exactly what you recommended. When I open the query I can see the correct fixed 2 decimal format, but when the table is created it loses the decimals. This is a make table query.

 

[Minty]

You can't force a number to store with trialling zero's, only display it. 23.00 is 23. I assume if you have 23.34 it stores that as you want?