Surpress #ERROR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks! That's the answer!!


Tom Wickerath said:
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 said:
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
Click to expand...
Click to expand...
 
Glad I could help!


Tom

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


lmv said:
Thanks! That's the answer!!


Tom Wickerath said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top