angelandgreg
Technical User
I have a query that shows all the people that are marked to volunteer to HelpAtHome.
Which is linked to a table with the days that the HelpAtHome people are also scheduled to volunteer on specific days each month.
I want to create a report, based on the query, but to output something like the following:
Oct06-Week1 Oct06-@eek2 ... Nov06-Week1
Person1 Person2 Person3
Current query result:
Name ScheduledDate
Cathy Filippone 10/2/2006
Nicole Meyer 10/3/2006
Shawn Kiesel 10/4/2006
Karen Singley 10/9/2006
Marlene Huckabone 10/12/2006
Cathy Filippone 10/23/2006
Shawn Kiesel 10/25/2006
Cathy Filippone 11/6/2006
Marlene Huckabone 11/9/2006
Karen Singley 11/13/2006
Marlene Huckabone 11/14/2006
Shawn Kiesel 11/15/2006
Cathy Filippone 11/27/2006
Which is linked to a table with the days that the HelpAtHome people are also scheduled to volunteer on specific days each month.
I want to create a report, based on the query, but to output something like the following:
Oct06-Week1 Oct06-@eek2 ... Nov06-Week1
Person1 Person2 Person3
Current query result:
Name ScheduledDate
Cathy Filippone 10/2/2006
Nicole Meyer 10/3/2006
Shawn Kiesel 10/4/2006
Karen Singley 10/9/2006
Marlene Huckabone 10/12/2006
Cathy Filippone 10/23/2006
Shawn Kiesel 10/25/2006
Cathy Filippone 11/6/2006
Marlene Huckabone 11/9/2006
Karen Singley 11/13/2006
Marlene Huckabone 11/14/2006
Shawn Kiesel 11/15/2006
Cathy Filippone 11/27/2006