Crosstab query?

  • Thread starter Thread starter Hanksor
  • Start date Start date
H

Hanksor

To make it simple, I have a table that has a Name field and a Qty field.
The name fields are unique with no duplicates. I need to create a sum of
all the Qty fields. Is a crosstab the way to go? I have tried, but can't
seem to get it to work properly. Or is a different approch needed? Any
help will be appreciated.

Hank in Oregon
 
Try this

Name,
Row heading Group by

Qty
Column heading Group by

Qty
Sum Value

May not work, just a thought... I'm a newbie...
 
Gave it a try, but unfortunately, it didn't give me the total of the Qty
column.
Thanks for you input.
 
Here it is maybe a little clearer;

Name QTY 0 QTY1
Tom 4 2
Joe 3 3
Bill 6 4
John 4 1


I need to calculate the sums of each QTY column. Does this make any sense?
 
If you are wanting the sum of the columns, you can use the Sum() function.

Select Sum([Qty 0]), Sum([Qty1])
From YourTable;
 
Back
Top