monthly quantity matching report

[daniellchiu via AccessMonster.com]

TABLEJAN

id quantity type
1 1 c
2 1 c
3 2 d
4 2 d

TABLEFEB

id quantity type
1 2 e
2 2 e
3 3 d
4 3 d
5 1 c
6 1 c


SPECIFACATION to make a monthly report
C of TABLEJAN match to columnY
D of TABLEJAN match to columnZ
E of TABLEJAN match to columnX

C of TABLEFEB match to columnX
D of TABLEFEB match to columnY
E of TABLEFEB match to columnZ

how can i make a monthly report (VALUE of SUM(quantity)) like this??? how
does the query should look like???

Month columnX columnY columnZ
JAN 0 2 4
FEB 2 6 4

 

[Duane Hookom]

Isn't this the same question you asked yesterday?

 

[daniellchiu via AccessMonster.com]

is different , cause i wonder if i could follow the SPECIFACTION to match out
the result

SPECIFACATION to make a monthly report
C of TABLEJAN match to columnY
D of TABLEJAN match to columnZ
E of TABLEJAN match to columnX

C of TABLEFEB match to columnX
D of TABLEFEB match to columnY
E of TABLEFEB match to columnZ

and the result become

Month columnX columnY
columnZ
JAN sum value of e sum value of c sum
value of d
FEB sum value of c sum value of d sum
value of e

thank you for you help by yesterday

 

[Duane Hookom]

If you want to transform one value into another, you generally create a table
that has one value in one field and another value in another field. You can
then join the one values to pull another value.