Adding totals in Query

[Gonzalo]

In my query I'm generating totals by groups (Routers) I have 4 groups the
field name is router, Sample Qty is one of my field and groups (Routers) is
the other field, my query returns the total by group/router,

This is what I get as an answer This is what I want
Field Field
SumOfQty Router(Group) SumOfQty Router(Group)
50 Loose Cases 150 Loose Cases
75 Palletized Cases 75 Palletized Cases
100 Sort & Segregate 100 Sort & Segregate



When I run this query I always want to see the "Loose Cases" +"Sort &
Segregate" field and give me the total under the Router/Group Field of "Loose
Cases.

Gonzalo Garcia

 

[Minton M]

In my query I'm generating totals by groups (Routers) I have 4 groups the
field name is router, Sample Qty is one of my field and groups (Routers) is
the other field, my query returns the total by group/router,

This is what I get as an answer This is what I want
Field Field
SumOfQty Router(Group) SumOfQty Router(Group)
50 Loose Cases 150 Loose Cases
75 Palletized Cases 75 Palletized Cases
100 Sort & Segregate 100 Sort & Segregate

When I run this query I always want to see the "Loose Cases" +"Sort &
Segregate" field and give me the total under the Router/Group Field of "Loose
Cases.

Gonzalo Garcia

Hi Gonzolo,

Can you provide more information? I don't see how the quantity should
change from 50 to 150 so without a little more info on the schema, I
can't really help.

-- James

 

[Gonzalo]

In my query I have 2 fields Qty and Router, I'm running a totals of the qty
for each router, I always want the sum of the Router called "Sort &
Segregate" to add to the sum of Loose Cases, and give me the total under the
field name of 'Loose cases, by adding this two fields totals is how I got
150, yet the other routers stayed with the sum of the original qty. I hope I
explained myself, if not let me know and I can attach a copy of my query.

Thank you, you guys are great.

G