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]

Re: Represent a Continuum

"Andrew Chanter" <helpme@radsolu tions.com.au> wrote in message news:<4CYjd.299 00$K7.17207@new s-server.bigpond. net.au>...[color=blue]
> 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?[/color]

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]

Re: Represent a Continuum

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
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Andrew Chanter" <helpme@radsolu tions.com.au> wrote in message
news:4CYjd.2990 0$K7.17207@news-server.bigpond. net.au...[color=blue]
> 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[/color]
9:00[color=blue]
> 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[/color]
left,[color=blue]
> 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[/color]
any[color=blue]
> suggestions on a methodology?
>
>[/color]