How do I Alter the Quantities in the Table? ie Inventory start 10

[cheapjeep]

I need to revise stock levels in inventory. Or enter the closing price of a
stock when the market closes.
Thanks

 

[Damian S]

Hi cheapjeep,

You shouldn't try to keep a closing total of items in an inventory, as this
can be simply calculated using a dsum or similar function.

The closing price of a stock product should probably be kept in a table
with a datestamp, so you know what date the closing price is applicable for.
You could also graph the rise/fall in price of a stock item over the days.

Hope this helps.

Damian.