Hi everyone,
I have a table in SQL that looks like this.
Type Crew Date Monday Tuesday Wednesday Thursay ...
Hours 14027 10/14/02 55.67 67.89 48.60 48.50
WO 14027 10/14/02 68.78 34.56 23.45 23.45
Ress 14027 10/14/02 45.67 23.45 56.78 56.78
Hours 14030 10/14/02 58.34 18.34 49.56 39.67
WO 14030 10/14/02 79.89 23.45 59.67 39.56
Ress 14030 10/14/02 34.56 67.34 79.89 45.78
.
.
.
I have to create a report that looks like that table group by crew. I don't need to see the date. It should look like this:
Monday Tuesday Wednesday Thursday
Hours 55.67 67.89 48.60 48.50
WO 68.78 34.56 23.45 23.45
Ress 45.67 23.45 56.78 56.78
Hours 58.34 18.34 49.56 39.67
WO 79.89 23.45 59.67 39.56
Ress 34.56 67.34 79.89 45.78
Do I need to use a cross-tab to do this?
Thanks,
Budjette
I have a table in SQL that looks like this.
Type Crew Date Monday Tuesday Wednesday Thursay ...
Hours 14027 10/14/02 55.67 67.89 48.60 48.50
WO 14027 10/14/02 68.78 34.56 23.45 23.45
Ress 14027 10/14/02 45.67 23.45 56.78 56.78
Hours 14030 10/14/02 58.34 18.34 49.56 39.67
WO 14030 10/14/02 79.89 23.45 59.67 39.56
Ress 14030 10/14/02 34.56 67.34 79.89 45.78
.
.
.
I have to create a report that looks like that table group by crew. I don't need to see the date. It should look like this:
Monday Tuesday Wednesday Thursday
Hours 55.67 67.89 48.60 48.50
WO 68.78 34.56 23.45 23.45
Ress 45.67 23.45 56.78 56.78
Hours 58.34 18.34 49.56 39.67
WO 79.89 23.45 59.67 39.56
Ress 34.56 67.34 79.89 45.78
Do I need to use a cross-tab to do this?
Thanks,
Budjette