Represent a Continuum

[Andrew Chanter]

I am developing a staff rostering system where staff are booked to work at
certain intervals thoughout the day for a given period of time (ie from 9:00
to 10:30). This is called a 'Booking'. Where staff are not booked, they
are considered available to be booked. One of the base level requirements
of the system is a screen view to show whether staff are available at a
requested time during the day based on their bookings. (ie if they are
already booked at that time then they are unavailable.) The preferred
method for this is a continuum that has the staff member's name on the left,
the times of day as graduations at the top, and the staff member's
availability represented as a band where the color red indicates the staff
member is unavailable (booked) and the color green the opposite.

Im sure Im not the first person in the world to be presented with this
requirement. Has anyone out there come up with anything similar or have any
suggestions on a methodology?

[Mal]

"Andrew Chanter" <he****@radsolutions.com.au> wrote in message news:<4C******************@news-server.bigpond.net.au>...

I am developing a staff rostering system where staff are booked to work at
certain intervals thoughout the day for a given period of time (ie from 9:00
to 10:30). This is called a 'Booking'. Where staff are not booked, they
are considered available to be booked. One of the base level requirements
of the system is a screen view to show whether staff are available at a
requested time during the day based on their bookings. (ie if they are
already booked at that time then they are unavailable.) The preferred
method for this is a continuum that has the staff member's name on the left,
the times of day as graduations at the top, and the staff member's
availability represented as a band where the color red indicates the staff
member is unavailable (booked) and the color green the opposite.

Im sure Im not the first person in the world to be presented with this
requirement. Has anyone out there come up with anything similar or have any
suggestions on a methodology?

This link is dealing with Time Lines..which is what you want...and
shoujld be easily modified...

http://www.mvps.org/access/reports/rpt0018.htm

HTH
Mal.

[PC Datasheet]

Another option is a screen with the times down the left side and staff names
across the top. For each staff member, their booked times could be shown red
and available times shown green. I can implement either methodology for you.
If you would like my help, contact me at my email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Andrew Chanter" <he****@radsolutions.com.au> wrote in message
news:4C******************@news-server.bigpond.net.au...

I am developing a staff rostering system where staff are booked to work at
certain intervals thoughout the day for a given period of time (ie from 9:00 to 10:30). This is called a 'Booking'. Where staff are not booked, they
are considered available to be booked. One of the base level requirements
of the system is a screen view to show whether staff are available at a
requested time during the day based on their bookings. (ie if they are
already booked at that time then they are unavailable.) The preferred
method for this is a continuum that has the staff member's name on the left, the times of day as graduations at the top, and the staff member's
availability represented as a band where the color red indicates the staff
member is unavailable (booked) and the color green the opposite.

Im sure Im not the first person in the world to be presented with this
requirement. Has anyone out there come up with anything similar or have any suggestions on a methodology?