How to ensure trailing zero's in query results ?

[edmscan]

I have a query that returns results .. and the results are fine, but the format I cannot figure out.

I want it to show .. 3.20 or 3.00, with 2 decimal places including showing the trailing zeros. I am getting 3.2 and not what I want.

Format in the table is "Fixed" .. and Precision 5, Scale 2 and Decimal 2. Field size is decimal.

Any advice appreciated ?

[June7]

I don't concern myself with decimal places in tables and queries. I set the Format and Decimal Places properties of controls on form/report.

However, with query in design view, select field in grid, look at the Properties Sheet. Try setting the Format and Decimal Places properties there.

[edmscan]

I don't concern myself with decimal places in tables and queries. I set the Format and Decimal Places properties of controls on form/report.

However, with query in design view, select field in grid, look at the Properties Sheet. Try setting the Format and Decimal Places properties there.

That .. worked. Thank you.
I never knew of that option. I tried it .. and for some reason it was not working but it was cause it was not saving. But .. it is fine now.