Desired Numerical Format in Query!

[cap.zadi]

Hi

Good Day

I have query and the below formula for caculations:

ResiduePernt: Nz([ResidueQty],0)/Nz([SampleQty],0)*100

and got values 19.4300003051758

How to format it up to two decimals places * 19.43

Note: Its very easy to use the "FormatPercent" format but its creating problems later on for calculation in reports.

[June7]

Using 0 as the Nz() alternate value in denominator can result in division by 0 error. Use 1 as the alternate.

Setting format property does not change the actual value. Format and FormatNumber functions result in a text value so if that causes issue, might have to convert back to a number, like: CDbl(Format(x, "0.00")).

Could use Round function. Be aware it uses even/odd (banker's rule) rounding.

[cap.zadi]

Hi Mr. June

Thanks for the usual feedback.

You are right and i will do correct accordingly.