Inventory Query Problem

[1943]

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

[orange]

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

[1943]

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

[orange]

Details of Allen's Inventory

http://allenbrowne.com/appinventory.html

[1943]

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

[orange]

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

'Assign the return value
        OnHand = lngQtyLast + lngQtyAcq - lngQtyUsed

[1943]

Hi,
Thanks for the reply.
Think I am going to reevaluate what I am trying to do.

Thank you very much!

DWH