calculating stock = stock - 1

[bricklebrit]

Hello,

On a subform [orderDetails], I'm attempting to create a system to keep track of stock of items.

After I enter the value for [seriesTitle] for the product entry, I would like the value [numInStock] to subtract one(NumInStock=NumInStock - 1) and display this value in the same subform.

Is there a simple expression that will achieve this?

Thanks in advance to any guidance or suggestions.

Jon

 

[bricklebrit]

I need to post a correction:

On a subform [orderDetails], I'm attempting to create a system to keep track of stock of items.

My values are:
[seriesTitle] is product name from the [OrderDetails] field
[unitsInStock] is the number of current items in stock stored in the [products] field

In a form, after I enter the value for [seriesTitle] for the product entry, I would like the value [unitsInStock] from the field [Products] to subtract one from itself (unitsInStock=UnitsInStock - 1) and display this value in the same subform.

Is there a simple expression that will achieve this?

I am having trouble even displaying the current value of [NumInStock] in the subform right now ....

Thanks in advance to any guidance or suggestions.

Jon

 

[Rich]

In simple terms Units on hand is Sum([UnitsRcd.]-Sum[UnitsSold]
This topic comes up for discussion on many occasions if you search for Stock you'll find many answers. Look in particular for posts by Pat Hartman on the subject.

 

[bricklebrit]

Rich -

Thanks for the help .. I've searched extensively for 'stock' and 'paul hartman', but cannot locate any messages. I have spent most of the day reading paul's other posts. I've figured a few things out, but am still unsure how to subtract a value from the table [products] and then redisplay that value on my form.

If you could help me along, I'm certainly a struggling novice at this.

The attempt is this:

Once the [ProductName] is selected, I'm attempting to subtract 1 from the [NumInStock] value in the field [Products] and display this value in my form.

While it seems like there should be an easy solution, all my attempts have resulted in sytax errors.

If you could direct me to any other resources or offer a simple solution, it would be much appreciated!

 

[boblarson]

Also, if you are trying to search for PAUL Hartman (as you typed) you won't get any results as his name is PAT Hartman. (You might want to search again)

BL

 

[Rich]

Look at Orders and Solutions sample db's one of them shows how to calculate a simple stock on hand, can't remember which one.