By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

Sum Query

P: 9
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
Feb 20 '09 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,306
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.
Feb 21 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.