Adding totals by group

G

Gonzalo

I have a query were I run totals by router, I need an if statement that says
SumOfQty for router "Loose Cases" = "Loose Cases" + "Sort & Segretate", but
also gives me the totals for each of the other routers by them selves.

Thank you
 
J

John W. Vinson

I have a query were I run totals by router, I need an if statement that says
SumOfQty for router "Loose Cases" = "Loose Cases" + "Sort & Segretate", but
also gives me the totals for each of the other routers by them selves.

Thank you
Click to expand...

You can see your computer. We cannot. What's a "router"? What's your query?

Please post the SQL of the query and indicate something about the relevant
fields - datatypes, relevant values, etc.

John W. Vinson [MVP]
 
Top