Crosstab query?

[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

 

[RedForeman ©®]

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...

 

[Hanksor]

Gave it a try, but unfortunately, it didn't give me the total of the Qty
column.
Thanks for you input.

 

[Hanksor]

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?

 

[Lynn Trapp]

If you are wanting the sum of the columns, you can use the Sum() function.

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