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

D

djames_d

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.
 
J

JackD

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I join the Tasks and Resources tables in MS Project/Access 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Full Join in MS ACCESS 2007? 7
Type mismatch in JOIN expression. (Error 3615) Join data stored asText and Number 4
How to get the list of users with PWA access and MS project client access 0
Alternative links between tasks in MS Project 2003 2
How do I get a Project 2003 Gantt chart to refresh from the DB? 4
Maintenance of Cost Rate Tables in MS Project 2010 0

Top