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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
This one you may want to take up with the folks in the Project newsgroup.
They may be more familiar with the data model.
 
Back
Top