need to show a week's worth of data in columns by day

[vircalendar via AccessMonster.com]

I have searched for answers on this but had no luck.

I have a table that tracks procedures done on patients, as well as the date
for which these are scheduled. For ease of scheduling, I would like to
produce a five-day display, based upon a date entered by hand, that has dates
across the top and a list of procedures already scheduled displayed in rows
below. For example, if I'm thinking about adding a procedure for 7/10/06, I
would like to see a display like this:

7/8 7/9
7/10 7/11
7/12

arteriogram drainage port place
arteriogram drainage
TIPS place embolization Port place
drainage drainage

TIPS

arteriogram

drainage

Obviously, a different day would be better.
I don't want to use a pivot table because I want people to be able to select
any of the cases by double-clicking it and having it open a patient data
table with more information. It seems to me that I could do this with a bunch
of subforms, each of which used the same child form but pulled from different
queries. Still, I suspect there may be a more elegant mechanism. Anybody?

 

[vircalendar via AccessMonster.com]

Well, I don't want the columns to be all jumbled like that, but I hope you
can get my drift...