Calculate inventory in report

[MikeO]

I use an inventory database that records received, sold, sshrinkage, etc. The
problem I have is that the "qty on hand" is calculated each time you view a
specific record.
I need a report that will summarize each item activity. One line per record
showing ordered, recvd sold etc. When I try to make a query with and expr: to
calculate the QTY on hand, I get an aggregate error.
Thank you
Mike

 

[Piet Linden]

I use an inventory database that records received, sold, sshrinkage, etc.The
problem I have is that the "qty on hand" is calculated each time you viewa
specific record.
I need a report that will summarize each item activity. One line per record
showing ordered, recvd sold etc. When I try to make a query with and expr: to
calculate the QTY on hand, I get an aggregate error.
Thank you
Mike

post your SQL.

You might want to check out Allen Browne's notes of calculating
quantity on hand.
http://www.allenbrowne.com/AppInventory.html

 

[MikeO]

Thanks,
That pointed me in the right direction.
Mike