Converting Table layout

[jb2_86_uk]

Hi all,



I have a table in Access which I need to summarise in order to use in an existing query. Apologies in advance if there is a ridiculously simple solution to this!

My company produces OEM components for use in various industries. I have a sales report query which I want to include information about the cost of each part produced. I have another table listing the cost of each item in terms of labour, materials, scrap, overheads etc.

My problem is this additional table is in the following format:

Part	Cost Type	Cost
AAA	Labour	3
AAA	Materials	6
BBB	Labour	2
BBB	Materials	7
CCC	Labour	6
CCC	Materials	12

However I really need it in the following format:

Part	Cost of Labour	Cost of Materials
AAA	3	6
BBB	2	7
CCC	6	12

Any suggestions how I can achieve this would be appreciated.

Thanks in advance
JB

[jb2_86_uk]

Solved!

As I suspected, it was embarrassingly simple - a Cross-tab query achieved exactly what I was looking for.