Query Access Database for Custom Project Fields

G

glenn

Hello,

I have saved a MS Project file as a MS Access database file.

I need to create a recordset with the following data:

TASK_NAME NUM_VALUE

TASK_NAME is from the MSP_TASKS table and NUM_VALUE is from
the MSP_NUMBER_FIELDS table.

NUM_VALUE represents a custom cost field.

In simple form, I created a MS Project with 2 tasks and a custom cost
associated with each task.

For example,

Tasks Custom Cost
Design Project $10,000
Code Project $50,000

My recordset for the first task would be

TASK_NAME NUM_FIELD
Design Project $10,000

and for the second task the recordset would be

TASK_NAME NUM_FIELD
Code Project $50,000

I am not sure how to link the data given the MS Project Schema design.

Thanks for any help.
 
R

Ray McCoppin

MSP_NUMBER_FIELDS table schema is defined like this.

MSP_NUMBER_FIELDS PROJ_ID Refers to a valid ID in the MSP_PROJECTS table.
NUM_CATEGORY Indicates whether the custom number category is Task (0),
Resource (1), or Assignment (3).
NUM_REF_UID Refers to a valid TASK_UID, RES_UID, or ASSN_UID in its
respective table, as determined by NUM_CATEGORY.
NUM_FIELD_ID Refers to a valid CONV_VALUE in the MSP_CONVERSIONS table.
NUM_VALUE The value of the custom number field.


So you will have to join the MSP_Projects table and the Task table to
MSP_Number_Fields table and also put a where clause with the field
NUM_FIELD_ID value.
 

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

Top