Weekly Summary Report

[susanh]

Good Morning,

I am trying to create a summary schedule report. I need to layout the columns to be
Monday Tuesday Wednesday Thursday Friday

then the rows to be the name of the individuals.

Employee1
Employee2
Employee3
Employee4


then I want to dynamically output the assigned work for the individuals based upon the day it is scheduled.

So the output would be something like

Monday Tuesday
Employee1 Training CompanyA
Meeting CompanyB
Lunch Lunch
Meeting companyC

and etc...

I just needs some suggestions on how to get this started.

Thanks
Sue

 

[TruthInSatire]

was all that supposed to be under monday for employee1?

 

[susanh]

it could be. depends on how many tasks are assigned to him in that table.

 

[lucidtech]

How is the database set up, if you're using one? If you could repost a better example of what you want the output to look like it would help. I'm pretty sure that what you need can be done with a query of a query nested in a small loop, though.