I have a table of employees. Each employee has records for work done in 3 different projects. I want to create a report that sorts on Employee name, then lists all the entries for project 1 , then all the entries for project 2, then all the entries for project 3. Each project is a separate table. They are all related by employee ID / name table.
How do i group the project results under each employee name - Currently all i can accomplish is a line for each project grouped under employee name.
What i get :
Name
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
what i want::
Name
project 1 - date - completed
project 1 - date - completed
project 1 - date - completed
project 2 - date - completed
project 2 - date - completed
project 2 - date - completed
project 3- date - completed
project 3- date - completed
project 3- date - completed
SubReports haven't been helpful as they have each employee listed in the entire report so i still don't achieve a grouping of all projects for a single name that repeats for the next name.
Now for most of you this will NOT be a complex report - but for me this is HUGE. I suspect it has to do with proper Union but i haven't a clue how to do this correctly ...
How do i group the project results under each employee name - Currently all i can accomplish is a line for each project grouped under employee name.
What i get :
Name
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
project 1 - date - completed
project 2 - date - completed
project 3 - date -completed
what i want::
Name
project 1 - date - completed
project 1 - date - completed
project 1 - date - completed
project 2 - date - completed
project 2 - date - completed
project 2 - date - completed
project 3- date - completed
project 3- date - completed
project 3- date - completed
SubReports haven't been helpful as they have each employee listed in the entire report so i still don't achieve a grouping of all projects for a single name that repeats for the next name.
Now for most of you this will NOT be a complex report - but for me this is HUGE. I suspect it has to do with proper Union but i haven't a clue how to do this correctly ...