monthly quantity matching report

  • Thread starter daniellchiu via AccessMonster.com
  • Start date
D

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
 
D

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
Click to expand...

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
 
D

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