L
lukeevans1000
(e-mail address removed) Sep 27, 10:11 am show options
Newsgroups: microsoft.public.project.vba
From: (e-mail address removed) - Find messages by this author
Date: 27 Sep 2005 02:11:27 -0700
Local: Tues, Sep 27 2005 10:11 am
Subject: Project 2000 sql query against assignments
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
We are using Microsoft project 2000.
We are not using Microsoft project server.
There are many projects using a shared resource pool.
I need to create a report which shows resources which are over
utilised. e.g If Bill is utilised for 6 days in a five day week I want
Bill on my report
I am failrly useful at sql (although if you want to do this bit for me
I will not be offended!!) but I just cant find the table / columns
where the daily work breakdown is stored.
I can see that the msp_assignments table contains the resources
assigned to each task but how do I know when that resource is working
on the task?
e.g. if I have a task which lasts for 3 weeks, and a Bill works on the
task in week 1 and week 3 - where is this recorded in the database and
how is it stored?
Any help greatly appreciated!
Kind regards,
Luke.
Newsgroups: microsoft.public.project.vba
From: (e-mail address removed) - Find messages by this author
Date: 27 Sep 2005 02:11:27 -0700
Local: Tues, Sep 27 2005 10:11 am
Subject: Project 2000 sql query against assignments
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
We are using Microsoft project 2000.
We are not using Microsoft project server.
There are many projects using a shared resource pool.
I need to create a report which shows resources which are over
utilised. e.g If Bill is utilised for 6 days in a five day week I want
Bill on my report
I am failrly useful at sql (although if you want to do this bit for me
I will not be offended!!) but I just cant find the table / columns
where the daily work breakdown is stored.
I can see that the msp_assignments table contains the resources
assigned to each task but how do I know when that resource is working
on the task?
e.g. if I have a task which lasts for 3 weeks, and a Bill works on the
task in week 1 and week 3 - where is this recorded in the database and
how is it stored?
Any help greatly appreciated!
Kind regards,
Luke.