creat report without code (repaired)

  • Thread starter HungTano via AccessMonster.com
  • Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top