Getting a number to appear with 2 decimal places

Bonamigo

New member
Local time
Today, 19:39
Joined
Nov 11, 2011
Messages
3
[SOLVED] Getting a number to appear with 2 decimal places

Hi,

Im writing a query that adds up numbers from different tables and creates a total count which is 43.9. The problem is that for the project I am working on needs it to appear as 43.90. How is it possible to add that extra 0 at the end? Round(43.9,2) did not work.

Any help is greatly appreciated

//EDIT: I know cstr(43.9) + "0" would work but can anyone come up with a way so that I dont need to turn it into a string?
 
Last edited:
Try this:
In the Table, Data Type = Number, Field Size = Double, Format = Standard,
In the Form for this field, Format = Standard.
 
Try this:
In the Table, Data Type = Number, Field Size = Double, Format = Standard,
In the Form for this field, Format = Standard.

Since it is in a query I can't really do that since those properties are not displayed. Thanks for the answer though!
 
Must be Double else decimal not shown
Fixed = 1000000.00
Standard = 1'000'000.00
 

Users who are viewing this thread

Back
Top Bottom