MS Access Query

[jenny23]

MS Access Query HELP PLEASE

Hello,
I am newbie in ms access, please help me.
I have this table:
Employee_Type Salary
------------ ------
Designer 35k
Developer 40k
Accountant 25k
Designer 30k
Designer 29k
Developer 30k
Accountant 22k

How do I make a query so that the table above changes to this:
Employee_Type Salary Designer Developer Accountant
------------ ------ ------- -------- ----------
Designer 35k 35k 0 0
Developer 40k 0 40k 0
Accountant 25k 0 0 25k
Designer 30k 30k 0 0
Designer 29k 29k 0 0
Developer 30k 0 30k 0
Accountant 22k 0 0 22k

Thanks.
Jenny.

 

[neileg]

You need a crosstab query. There's a query wizard to help you do this.