Error message/Stock Reports

[samsam]

Can anybody help I have a simple Access database which will tell you how much stock you have, however if there is full stock I get the following message in the text box "#Error", how can I get rid of this to say for example "no need to re-stock" or something, the message appears in a form in a text box and the calculation I have is as follows:

=[ReorderPoint]-[qry_todays_totals Subform].[Form]![SumOfQuantity]

(The stock levels vary for all of the different products.)

Also can anybody advise me how to send the above information to a word document, I have this set up already using a macro, however the information that is sent to word, does not show any stock which has been sold it will only show the full stock list without the sales information, for example if I have 20 roses at the start of the day and the re-order point is 20 as well, and I sell 5 the list will not update and show that I need to re-order 5, it will still only read 20 and 20?

I would appreciate any help.

Regards,

John

 

[tomj]

My guess is that since there are no orders that day, you have nothing to subtract from the reorder point. The value being returned for "SumOfQuantity" a 'null', not a zero and therefore the calculation is erroring out - try this:

=[ReorderPoint]-NZ([qry_todays_totals Subform].[Form]![SumOfQuantity])