Time Schedule display in access

[snoopy2003]

Hello,

I wish to implement time schedule in access to manage resources.
My time table should display day/hour view of 2 month (24 hours for each day and 2 months view).

I thought to create a table which will contain the following data:
resourceID (key)
date (key)
hour (key)
status



If a resource will be ordered - I will insert records to the table for the relevant data/hour.

I do not know how to display the view in access form.
I attached an example of the desired look (made in excel).
I wish to color the table with appropriate colors and let the user choose schedule time by filling the squares with some char (like: 'x').

How can I display my table in this format ? Is it possible ?

Thank you for your help

[HiTechCoach]

Here is a Schedule Grid Click Here) you can use.

[snoopy2003]

Amazing !

Thank you for the helpful link.

I appreciate your help
Thank you

[HiTechCoach]

You're welcome.

Glad that was helpful. I hope you will find lots of helpful information on my site.