D
daniellchiu via AccessMonster.com
here is what i have got
SELECT "JAN" as Mth , id, quan, type
FROM tablejan
UNION ALL select "FEB", id, quan, type
from tablefeb;
TRANSFORM Sum(union.quan) AS quanOfSum
SELECT union.Mth
FROM [union]
GROUP BY union.Mth
PIVOT union.type;
TABLEJAN
id quan type
1 1 c
2 1 c
3 2 d
4 2 d
TABLEFEB
id quan type
1 2 e
2 2 e
3 3 d
4 3 d
How do i make a query with row total????help please
month SUM(e) SUM(d) SUM(c)
JAN 0 4 2
FEB 4 6 0
total * * *
SELECT "JAN" as Mth , id, quan, type
FROM tablejan
UNION ALL select "FEB", id, quan, type
from tablefeb;
TRANSFORM Sum(union.quan) AS quanOfSum
SELECT union.Mth
FROM [union]
GROUP BY union.Mth
PIVOT union.type;
TABLEJAN
id quan type
1 1 c
2 1 c
3 2 d
4 2 d
TABLEFEB
id quan type
1 2 e
2 2 e
3 3 d
4 3 d
How do i make a query with row total????help please
month SUM(e) SUM(d) SUM(c)
JAN 0 4 2
FEB 4 6 0
total * * *