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.
 

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
Type mismatch in JOIN expression. (Error 3615) Join data stored asText and Number 4
Relationship - Outer Join - Microsoft Access 2002 1
Join Question? 2
Join 2 tables 1
How to export table from outlook into ms access table? 0
Nested JOIN clauses - order of precedence (Access 2007) 2
Cartesian join in Access 0

Back
Top