Running talley

[Bvincey2002]

I have created a running talley report that gives the total $$ value in the report. When I look at the reportit shows the same product listed multiple times. I figured out that the issue lies in the query that I created for the report. For example. it will say

Part # Quantity Cost per ea
widget1 20 30.00
widget1 5 30.00

I have realize that the query is is pulling from separate orders and that is why the same part number is listed several times. What i want to do in my query is to consolidate the total quantities together to look like this. The sum icon is not working in this particular circumstance.

Part# Quantity Cost per ea


widget1 25 30.00

All my data is working off of one Table. Could some one help me with this?

[alansidman]

Change your query to an Aggregate query. Here is a link to show you how to do that

http://www.techonthenet.com/access/f...umeric/sum.php

[Bvincey2002]

Change your query to an Aggregate query. Here is a link to show you how to do that

http://www.techonthenet.com/access/f...umeric/sum.php

I have tried using the totals button and it does not work. The quantities are from different orders but I do not see why it would not be totaling them together?

[alansidman]

Do not group on the order numbers. Group on the part number only.