Default Value "0" in Query Extended Price filed (1 Viewer)

[sandya]

Hi friends, can anyone solve my issue

How to set a Default value "0" in Query Extended Price Calculated filed ?

i have attached the screenshot with explanation can you please replay how to changes the formula.

i have used below following functions but there is no workout.
Extended Price: CCur([Qty]*[BPrice])
Extended Price: CCur(Nz([Qty]*[BPrice],0))
Extended Price: Nz([Qty]*[BPrice],0)
Extended Price: ([Qty]*[BPrice])
Extended Price: IIf(IsError(([Qty]*[BPrice])),0,([Qty]*[BPrice]))

Thanks,
Sandhya.

 

[JHB]

You can't do that in a query for a new record, only at table level.

 

[sandya]

Thanks for replay...

At least possible in the Query related Subform? If we set the default value "0" in the Subform on Extended Price filed then after data entry getting an Error Message (Field Cannot be updated) Or If we remove the default value 0 then working is good without any error message. So Just i need a default value in subform at least.

 

[CJ_London]

nz applies to a single value, so try

Extended Price: Nz([Qty],0)*nz([BPrice],0)

 

[sandya]

Extended Price: Nz([Qty],0)*nz([BPrice],0) This function did't work in the query as default value. I've adjusted in the subform.

Thanks for suggestion