By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 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+
4 Replies


P: 39
are you trying to do this with a query or a form? How are you adding these items to your total count of product? Little more info in order to help.

-Will
Feb 20 '09 #2

P: 98
http://bytes.com/topic/access/answer...culating-total

This might be similar to your situation
Feb 20 '09 #3

P: 9
Actually, I accidentally right clicked on the column and hit the Sigma sign that said totals. After doing that, I looked at the query and datasheet view and did exactly what I wanted it to do. Thanks for the advice though. I'm sure it will come in handy down the road.
Feb 20 '09 #4

NeoPa
Expert Mod 15k+
P: 31,417
It's very similar anyway. The link just gives the detailed steps of how to do it.

Welcome to Bytes!
Feb 22 '09 #5

Post your reply

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