davetough
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks cap
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;