Help in creating a crosstab for scheduled dates in table ......Please

[johnham40]

I have a table called assignments. This table has resources dedicated to a task. The task has a startDate, EndDate, Duration, workperday and a ProjectID column
I am trying to create a crosstab grouped by Resource. How do I get the table to start at the first date it occurs and spreads the EstWork evenly over through the EndDate Thanks in advance

ProjectID	RoleID	Workperday	StartDate	EndDate	EstWork	Duration
1	51	8	1/24/14	2/28/14	197	25
1	51	8	1/14/14	1/17/14	25	3
1	32	8	1/7/14	1/15/14	56	7

[June7]

Probably with a lot of VBA code.

Duration excludes weekends and holidays?

What is Resource?

What is EstWork - hours?

[johnham40]

Probably with a lot of VBA code.

Duration excludes weekends and holidays?

What is Resource?

What is EstWork - hours?

June7 thanks for getting back to me, unfortunately I was away from my PC, till now

You are correct the duration should exclude weekends and holidays
The resource is the RoleID (group responsible for the task)
And you are correct again EstWork is the overall hours of the assignment

Once again thanks for taking the time to look at this for me

[June7]

Still thinking this will require VBA and temp table. These threads discuss methods to generate records between a range of dates.

https://www.accessforums.net/queries...nge-41313.html

https://www.accessforums.net/program...ort-41142.html

[johnham40]

June7

Thanks for the link I used that code and manipulated it to suit my needs
Much appreciated