Working with databases is new to me so thank you for any assistance you can provide. I have a database where data is stored as follows:
Table: Rates
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 61, bgcolor: transparent"] Company<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Item<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] Labor Rate<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] Matl Rate<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 45<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 87<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 56<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 75<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 42<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 48<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 92<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 51<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 63<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 43<o></o>
[/TD]
[/TR]
</tbody>[/TABLE]
I want to write query to return the following:
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 43, bgcolor: transparent"] Item<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Labor Rate<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Matl Rate<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] BBB Labor Rate<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] BBB Matl Rate<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 45<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 87<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 48<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 92<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 56<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 75<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 51<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 63<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 42<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 43<o></o>
[/TD]
[/TR]
</tbody>[/TABLE]
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!
Table: Rates
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 61, bgcolor: transparent"] Company<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Item<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] Labor Rate<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] Matl Rate<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 45<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 87<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 56<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 75<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 42<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 48<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 92<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 51<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 63<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o></o>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"] 43<o></o>
[/TD]
[/TR]
</tbody>[/TABLE]
I want to write query to return the following:
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 43, bgcolor: transparent"] Item<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Labor Rate<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Matl Rate<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] BBB Labor Rate<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] BBB Matl Rate<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Pipe<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 45<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 87<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 48<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 92<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Beam<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 56<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 75<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 51<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 63<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Cable<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 42<o></o>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o></o>
[/TD]
[TD="width: 61, bgcolor: transparent"] 43<o></o>
[/TD]
[/TR]
</tbody>[/TABLE]
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!