Query Help!! 1

[dj982020]

I have this table: Table_A
DATE BILL AMOUNT
8/20/04 Gas $30
9/15/04 Electric $20
10/4/04 Water $10
7/30/04 Cable $60
8/1/04 Phone $25
8/5/04 Electric $22
9/2/04 Gas $28
9/1/04 Water $14

I want this table: Table_B
Gas Cable Electric Phone Water
$30 $60 $20 $60 $10
$28 $0 $22 $0 $14

I'm not sure if a simple query will do this. Please Help!!

Thanks,
Danyelle

 

[lespaul]

search the help for crosstab query.

Leslie