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