Fastest way to create table base on database

[srikandi2000]

Dear all,


I have a flat database which look like this:


Area ID_Code Income

Newyork A 500

Manhattan A 1000

Newyork B 250


How can i make another table which sum the income base on ID_code? The new table should look like


Area A B

Newyork 500 250

Manhattan 1000 0


I have been trying to use ms.query but i keep getting syntax error with the sum query

"... sum(iif(

data$.ID_code=" & chr(34) & "A" & chr (34) & ",data$

.income,0) AS Income FROM ..."


Thanks in advance

PS: Please forgive me if I did not give feedback soon.

 

[srikandi2000]

Forgot to mention that i cannot use pivot table. thanks