Surpress #ERROR

[lmv]

is there a way to surpress this so the form doesn't show #Error if there is
nothing entered in the UnitPrice...? Once I enter info then this goes away.
Unit price in table set to >=0

CCur([Order Details].UnitPrice*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Thanks

 

[Tom Wickerath]

Try using the Nz function to convert a null to zero. Something like this
(untested):

CCur(Nz([Order Details].UnitPrice,0)*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[lmv]

Thanks! That's the answer!!

Try using the Nz function to convert a null to zero. Something like this
(untested):

CCur(Nz([Order Details].UnitPrice,0)*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

is there a way to surpress this so the form doesn't show #Error if there is
nothing entered in the UnitPrice...? Once I enter info then this goes away.
Unit price in table set to >=0

CCur([Order Details].UnitPrice*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Thanks

 

[Tom Wickerath]

Glad I could help!


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Thanks! That's the answer!!

Try using the Nz function to convert a null to zero. Something like this
(untested):

CCur(Nz([Order Details].UnitPrice,0)*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

is there a way to surpress this so the form doesn't show #Error if there is
nothing entered in the UnitPrice...? Once I enter info then this goes away.
Unit price in table set to >=0

CCur([Order Details].UnitPrice*[Order
Details].Quantity*(1-[Discount])/100)*100 AS ExtendedPrice,

Thanks