Adding totals by group

  • Thread starter Thread starter Gonzalo
  • Start date Start date
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
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding totals in Query 2
Sum of Qty 2
Query summing problem 1
Sales Summary Date Range Filter Question? 4
Can somebody help me with this cross tab query? 1
working with SUM 2
How do you remove a Group By from a query? 2
Query to display highest totals 1

Back
Top