create crosstab query form table

i have table with zone, pounds, cost, qty
is it possible w/ crosstab query to have
zone be field names
pounds be rows
and cost and qty be calculated for each zone?
thank you - i attached table
example22.mdb
davetoughAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
for the cost

TRANSFORM Sum(tbl1.cost) AS SumOfcost
SELECT tbl1.pounds, Sum(tbl1.qty) AS [Total Of qty]
FROM tbl1
GROUP BY tbl1.pounds
PIVOT tbl1.zone;
0
 
Rey Obrero (Capricorn1)Commented:
is this what you want

TRANSFORM Sum(tbl1.qty) AS SumOfqty
SELECT tbl1.pounds, Sum(tbl1.qty) AS [Total Of qty]
FROM tbl1
GROUP BY tbl1.pounds
PIVOT tbl1.zone;
0
 
davetoughAuthor Commented:
Thanks cap
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.