Arranging data within table

[bhussin74]

Hi everyone...need your help as I'm spend ages to solve the problem.

My problem is I have a table just like this

Sample Machine Element Value
123 2 Ca 5
123 2 V 4
123 2 Vi 2
..
..
My Question is how can I make the table like this

Sample Machine Ca V Vi .....
123 2 5 4 2


Thanks for the help

Aboo

 

[PHV]

Take a look at CrossTab query or PivotTable.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244