Query MS Access for Custom Fields

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

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.