How do I join the Tasks and Resources tables in MS Project/Access

I have exported a MS Project file to MS Access for reporting purposes and am
attempting to join the MSP_RESOURCES table to the MSP_TASKS table. My
initial analysis shows that there is no direct link between the two tables.
I have discovered a RES_CAL_UID and TASK_CAL_UID column that could be a
potential join; however, only the RES_CAL_UID has values, the TASK_CAL_UID is
-1 for all entries.

If anyone has a tip on how I can join these two tables, I'd greatly
appreciate it.

Thank you in advance. I initially posted this in the Access group and was
directed here.

JackD
Wed Nov 17 16:55:21 CST 2004

There is no need to do a join between them The data is already in the
MSP_ASSIGNMENTS table, You can join that to MSP_TASKS and MSP_RESOURCES
based on the ids.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.
"djames_d" <djames_d@discussions.microsoft.com> wrote in message
news:A9C109EA-1108-484E-9E9A-2BF3EF7CED11@microsoft.com...
> I have exported a MS Project file to MS Access for reporting purposes and
am
> attempting to join the MSP_RESOURCES table to the MSP_TASKS table. My
> initial analysis shows that there is no direct link between the two
tables.
> I have discovered a RES_CAL_UID and TASK_CAL_UID column that could be a
> potential join; however, only the RES_CAL_UID has values, the TASK_CAL_UID
is
> -1 for all entries.
>
> If anyone has a tip on how I can join these two tables, I'd greatly
> appreciate it.
>
> Thank you in advance. I initially posted this in the Access group and was
> directed here.
>