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