Schedule Week View with days as columns and positions as rows

[Curtis]

I'm working on a scheduling database in Access 2003. Is it possible using
Forms/Subforms to create a view that will have each of the seven days of the
week as columns across the top of the form, each of our scheduled concessions
as rows down the side, and schedule details (start time, employee number,
employee name) as a subform/detail view in which is filtered based on the
column it's in (date) and by the row it's in (concession). I'll try to draw
the desired result as ASCII art:

| Monday | Tuesday | Wednesday |
| 4 July 2005 | 5 July 2005 | 6 July 2005 |
--------------+--------------+--------------+--------------+------
Front Counter | 9:00 4 Doe,Jo| 9:00 3 Smith,|10:30 4 Doe,Jo|
|15:00 5 Doe,Ja|15:00 2 Smith,|16:00 2 Smith,|
--------------+--------------+--------------+--------------+------
Left Counter | 9:00 5 Doe,Ja| 9:00 4 Doe,Jo| 9:00 2 Smith,|
|15:00 4 Doe,Jo|15:00 3 Smith,|15:00 3 Smith,|
--------------+--------------+--------------+--------------+------
Back Counter | 9:00 3 Smith,|10:00 2 Smith,|10:00 3 Smith,|
|15:00 2 Smith,|15:00 4 Doe,Jo|15:00 5 Doe,Ja|
--------------+--------------+--------------+--------------+------
| | | |etc...

Ideally the Employee number would be a text field that would be editable.
Everything else should be derived from the related tables which are something
like this (related fields have the same name in all tables in which they
appear).

Concessions:
ConcessionID
ConcessionName

Employees:
EmployeeID
EmployeeLastName
EmployeeFirstName

Schedule:
AutoID
ShiftDate
ShiftTime
ConcessionID
EmployeeID

Anyone seen any thing like this or have any thoughts?