Combining output on one row

[bwheeler]

I have the following data set:

Table: Mytable

Account	Type	Amount
1220	Actual	500
1220	Budget	1000
2330	Actual	3000
2330	Budget	2000

How do I structure my query to produce the following output:

Account	Actual_Amt	Budget_Amt
1220	500	1000
2330	3000	2000

I believe I will need an inline query but not sure of the correct syntax. I'm very new to Access.

Thanks,
Bruce

[CJ_London]

use a crosstab query

Account will be the row header
Type will be the column header
Amount will be the value (and summed)

Note Type is a reserved word, if that is your real field name, change it to something else (such as AccountType)

[bwheeler]

Ajax,

Thank you very much! That's exactly what I needed.