Scheduling

[Bob Rice]

I need to write a scheduling program in Access.

I have rooms that I want to schedule and show the occupied dates for. I
would like
to create a form that would display the status of the rooms in a tabular
form (much the way Microsoft Project does it):

The rooms numbers and dates in and out dates are in a table

Date
10/01 10/02 10/03 10/04
Room
1 X X X
2 X
3 X

Where the X's show the dates occupied or scheduled.

Is there a function that does this?

 

[PC Datasheet]

Bob,

I have developed two reservations modules that would work for you. The first
reports similar to what you show here and the second diagrammatically shows
all the rooms and for any selected day shows which rooms are reserved. I
could work with you to apply either of these to what you need. If you are
interested, contact me at my email address below.

 

[Tom Ross]

What is your table structure

assuming a table like the following

ROOM DATE Status (1 means scheduled 0 means not)
1 10/01 1
2 10/01 1
1 10/03 1
1 10/04 1
1 10/02 0

You could use a CrossTab Query to get a table like you show below.

Tom