format number in Query

[drmichaelw]

SELECT system, total, system/total AS [sys/total]
FROM table;

Iwould like to return only one decimal place instead of many for [sys/total].
How can I format to one decimal place?

 

[ajdesalvo]

Try this:

SELECT system, total, Format(system/total,"###,###,###.#&quot AS [sys/total] FROM table;
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[drmichaelw]

Worked well!
How do I add in the leading and trailing 0 before and after the decimal place.

 

[ajdesalvo]

Replace the # symbol with a zero (0).

You can see all the Format Property information right from the embedded Access Help. Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"