A challenge for you...

[Steve]

I have been asked to create a "diary" by one of my clients for his staff. It
is for a database that stores consultant appointments in a Appointment_Date
datetime field. The purpose of the diary is so that his staff can see where
they have booked appointments (and therefore what time slots are free) and
can manage consultants time easily.

Ideally it should have:

- Four columns, one for each of the next four weeks
- Rows split into each day (i.e. 5 working days)
- Each day split into sub rows with time slots of 0900-1800 hours, with half
an hour per slot (e.g. 0900, 0930, 1000, 1030 etc.)

I realise that this is awkward in access so a lot of the above is not
possible, however the *minimum* criteria is to produce a report that will
show ALL half-hour time slots (whether having an appointment allocated or
not).

----

My initial thoughts on how to do this is to create a table which stores days
and hours in two fields, then somehow relating this table to the appointment
times.

Any further suggestions as to how I can do this?

 

[Duane Hookom]

Take a look at the calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There are some
week-at-a-glance reports that might be close to what you need.

 

[Larry Daugherty]

Has your client heard of this crafty little application named
"Outlook"? It has all that you want and more, including the ability
for others to see time commitments, etc.

HTH