Just check for that condition and adjust your formula accordingly.

Got it... I kept waiting for Rick to see the error and address it then wondered if i missed something so rewatched... read through the code again... I kept thinking it had do be me lol.  Thanks Sami

Can I ask you another question Sami?  In this lesson we calculate the profit, the margin, the Markup and the total unit cost.  The calculations are done in the forms.  Is there a way to access that information and put it into a continuous form type format so we could see all of the products numbers for each product?  i tried a query referencing the box and it doesnt pull the calculated value. i am thinking that if the calculations are being done in the form that the results are only available when the form is open?  So we cant do anything with the numbers?

Hi Shallena
Reproduce the same calculations in the query without referencing the form.