Format Trailing Zero in Query Design 1

[Mantle51]

Hello,
I've put the following in my criteria field in query design with the intention of forcing trailing zeros in recordset output, but it will not work. The only instances when 6 decimal places are shown is when they are non-zero.

=Format([tblPosition].[Price],"0.000000")

Thanks.......Mick

 

[PHV]

Clear the criteria cell and put this in the field cell:
FormattedPrice: Format([tblPosition].[Price],"0.000000")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mantle51]

Ahaaa...in the field section.

Thank you very much!