Is it possible to transpose just 1 field like this?

W

wayne9999

http://img143.imageshack.us/img143/5319/untitled19zn.jpg[/URL
[URL=http://www.imageshack.us][img:46da3ca385]http://img271.imageshack.us/img271/3497/untitled8mn.jpg[/img:46da3ca385][/URL

I need to transpose the labor type from the 1st table into the 2n
table with the data field as hours worked

I need to include the data (retrieved from a database) into a repor
after transposing
I tried to use the PivotTable wizard by creating a form but found tha
it cannot be linked to a report.

Can it be programmed such that the labor type is transposed and fo
each labor type (1,2,3,.....), the respective hours worked would b
as shown in the 2nd table[/URL]
 
Top