calculating fields in a table 1

[banburyexperience]

Given that a table has the following fields:<br><br>GoodsIn Stock, GoodsSold, Balance, and Re-orderLevel<br><br>How does one perform calculations i.e.<br><br>How can one display data showing that Goods sold reduces the goods in stock field, and notify the user when the Re-orderLevel sum arrives.<br><br>I'd appreciate any suggestions.

 

[famousb]

if you're using a form to do orders and what not, you could have a text box that says &quot;Reo-order&quot; (let's call the text-box &quot;Alert&quot that has it's Visible property set to No.&nbsp;&nbsp;then on the GoodsSold field (or wherever you want) you can put in the AfterUpdate property something like:<br><b><br>If [GoodsinStock]-[GoodsSold] &lt; [Re-order Level] Then<br>Me.Alert.Visible = True<br>Else<br>Me.Alert.Visible = False<br>End if<br></b><br><br>this is all given that you're GoodsInStock is recalculated after every entry.<br><br>that's just one solution, there are probably endless others.<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>