Problem formatting a weekly schedule report

[Guest]

I am trying to build a report to show an employee schedule by week. Any help
on this would be greatly appreciated, as I am not sure how to get the data to
format correctly.

Here is the way my data is stored in the table:

Employee_SSN(this will actually be a name on the report, linked from another
table)
Work_Location
Work_Date
S_Time (Starting time of shift)
E_Time (Ending time of shift)

Employees may have multiple shifts on a single day (ie. split shifts). I
want to be able to print weekly reports for their schedule. I am trying to
get the report to look like this:

Day1 Day2
etc... Day7
Employee 1 Location Location
Location
S_Time/E_Time S_Time/E_Time
S_Time/E_Time

Employee 2 Location Location
Location
S_Time/E_Time S_Time/E_Time
S_Time/E_Time
Location Location
Location
S_Time/E_Time S_Time/E_Time
S_Time/E_Time

Like shown above, an employee may have one or multiple shifts. I have
tried making a cross tab query to manupliate the data for the report, but can
only get it to return one record per person per day and this won't work.

I could really use some advice on this, if it is possible to do it, and what
direction I need to take this to make it work, either in the report
formatting or in a query generating the data. I am going to keep working on
it, but not sure how to get it to work

Thanks,
James Stephens

 

[Duane Hookom]

There are some calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

To get multiple shifts, you might be able to use the generic concatenate
function as value from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane