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
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