I am having a problem with getting the qty rec, qty sold and instock to work. It is not adding to the existing stock on hand.
Can someone PLEASE help,
Thanks,
DWH
I am having a problem with getting the qty rec, qty sold and instock to work. It is not adding to the existing stock on hand.
Can someone PLEASE help,
Thanks,
DWH
Is this your entire database?
QtyOnHand = QtyRecd- QtySold
You may want to look here for some inventory data models
http://www.databaseanswers.org/data_models/index.htm
and
http://www.databaseanswers.org/data_...ders/index.htm
http://www.tech-archive.net/Archive/.../msg00082.html
Hi,
Thanks for the reply.
No this is not the entire db. I am trying to modify an existing db.
I created this db to try and figure out how to use Dsum or Sum.
I read the article by Allen Browne on Inventory Control.
His suggestion was to use Dsum. How do I do this?
Thanks,
DWH
Details of Allen's Inventory
http://allenbrowne.com/appinventory.html
He says, Just use DSum() on the table of acquisitions to get the number acquired for any product . This for a simple db.
How do I do this. I don't know how to apply this function DSum.
I have tried and tried with no success.
Do you know how?
Thanks,
DWH
Here is an example of DSum, and you will see code that shows what DSum is really doing.
http://www.techonthenet.com/access/f...omain/dsum.php
In Allen's example
http://allenbrowne.com/AppInventory.html
he is using SQL to calculate " QuantityAcq"
and he uses this to calculate " lngQtyAcq "
He also does this with " lngQtyLast" and " lngQtyUsed" and then does
Code:'Assign the return value OnHand = lngQtyLast + lngQtyAcq - lngQtyUsed
Hi,
Thanks for the reply.
Think I am going to reevaluate what I am trying to do.
Thank you very much!
DWH