Patch Windows Pt3 - Calender Schedule Report

[jriechers]

I need to create a report that shows in calendar form each patch window, the date and the time they start.

tblPatchWindows includes the following fields:
1. PatchWindow
2. PatchDate
3. PatchStartTime

I would like them to display something like the following in a report: (ignore "-")

------------------------4/1/08--4/2/08--4/3/08
PatchWindow1--12:00a
PatchWindow2--------------3:00a
PatchWindow3-------------------------9:00p

Thats the basics of what I want. What I really want is to show time blocks. Say PatchWindow1 is from 12:00a to 1:00a I want to show that block of time as occupied somehow. If I need to export this to excel somehow thats fine, but I dont know the best way to achieve what I need.

Maybe a better format would be:

------------------------4/1/08---4/2/08---4/3/08
12:00a--------------Patch1
1:00a----------------------------Patch2
2:00a----------------------------------------Patch3

[NeoPa]

How about something like :

TRANSFORM First(subP.PatchWindow) AS PatchWindow
SELECT subP.PatchDate
FROM (SELECT PatchWindow,
             PatchDate,
             DatePart('h',[PatchStartTime]) AS pHour
      FROM tblPatch) AS subP
GROUP BY subP.PatchDate
PIVOT subP.pHour