Sum Query

[yeske03]

I have a query built that shows my products, whether the product was put into inventory or sold, the quantity of the transaction, and an expression built that will make the quantity become negative for the sales transactions.

What I am having trouble with now is creating a new query or report that will sum my transactions.

For example: I purchesed 6 of product A and 4 of Product B and have only sold one of each. I want it to be able to tell me how many of each are left.

THANK YOU

[NeoPa]

I have moved this thread into the answers forum, where it has a chance of getting an answer.

If you post the layout of the table(s) where the information is held we can look at giving some help on this.