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

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

[MVP] S.Clark

This one you may want to take up with the folks in the Project newsgroup.
They may be more familiar with the data model.
 

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

Three table join 2
Simulating A Full Outer Join in Access from 3 Tables 12
Microsoft Access can't represent the join expression ..... in Desi 1
Joining a Budget and Actual Table 3
Joining two tables based on timeframes 6
How do I force exact match in text inner join 4
Query problem (MS SQL and MS Access tables) 2
Reconciling Two Tables With Similar Information 1

Top