I am trying to make a chart that shows when people have been scheduled. I want it to look something like this:
2/12 2/13 2/14 2/17 2/20 2/23 2/24
John Schd Schd Schd
Laura Schd Schd Schd
Lori Schd Schd Schd
This would do this for all 350 people that is in the database. The data would be retreived from a query [ContractUnion]. This table lists all information about the event, id (PK), day, time, location, and it lists who is scheduled to be there that evening and all of their information, id (PK), address, city, state, zip, phones. There is an unlimited number of people who can be scheduled on a certain day, because there may be several events at several different locations.
I am trying to make this chart to give our schedulers a visual idea of who has already been scheduled and who is not already scheduled.
My question is, how do I get it to say "Schd" under a specific date and person's name?
2/12 2/13 2/14 2/17 2/20 2/23 2/24
John Schd Schd Schd
Laura Schd Schd Schd
Lori Schd Schd Schd
This would do this for all 350 people that is in the database. The data would be retreived from a query [ContractUnion]. This table lists all information about the event, id (PK), day, time, location, and it lists who is scheduled to be there that evening and all of their information, id (PK), address, city, state, zip, phones. There is an unlimited number of people who can be scheduled on a certain day, because there may be several events at several different locations.
I am trying to make this chart to give our schedulers a visual idea of who has already been scheduled and who is not already scheduled.
My question is, how do I get it to say "Schd" under a specific date and person's name?
