H
HungTano via AccessMonster.com
Hi everybody,
I have 1 table with 5 fields : MaID, NhomID, LoaiID, HangID, Amount.
MaID NhomID LoaiID HangID Amount
001 EU High H1 500
001 EU High H2 450
001 EU Med H1 700
001 EU Med H2 350
002 EU High H1 400
002 EU High H2 950
002 EU Med H1 200
002 EU Med H2 100
003 BA High H1 500
003 BA High H2 400
003 BA Med H1 500
003 BA Med H2 100
.............
............
Note: Field LoaiID has only 2 values : High and Med
Field HangID has only 2 values : H1 and H2.
I want to creat a report as follows :
NhomID : EU
------------------------------------------------------------------------------
-------------------------------------------
MaiD High
Med
H1 H2 Sum of High H1
H2 Sum of Med
------------------------------------------------------------------------------
-------------------------------------------
001 500 450 950 700
350 1050
002 400 950 1350 200
100 300
Anybody help me to creat above report ( without code if possible).
Thanks in advance.
I have 1 table with 5 fields : MaID, NhomID, LoaiID, HangID, Amount.
MaID NhomID LoaiID HangID Amount
001 EU High H1 500
001 EU High H2 450
001 EU Med H1 700
001 EU Med H2 350
002 EU High H1 400
002 EU High H2 950
002 EU Med H1 200
002 EU Med H2 100
003 BA High H1 500
003 BA High H2 400
003 BA Med H1 500
003 BA Med H2 100
.............
............
Note: Field LoaiID has only 2 values : High and Med
Field HangID has only 2 values : H1 and H2.
I want to creat a report as follows :
NhomID : EU
------------------------------------------------------------------------------
-------------------------------------------
MaiD High
Med
H1 H2 Sum of High H1
H2 Sum of Med
------------------------------------------------------------------------------
-------------------------------------------
001 500 450 950 700
350 1050
002 400 950 1350 200
100 300
Anybody help me to creat above report ( without code if possible).
Thanks in advance.