Calculate inventory in report

  • Thread starter Thread starter MikeO
  • Start date Start date
M

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
 
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
Click to expand...

post your SQL.

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