469,125 Members | 1,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

sum query

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.

Feb 20 '09 #1
4 1050
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.

Feb 20 '09 #2

This might be similar to your situation
Feb 20 '09 #3
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
32,161 Expert Mod 16PB
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.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.