Resource usage

[Prav]

Hi I have 50 projects in my ms access 97 database. They all have a different start and finish date and the total number of hours. I would like to produce a resource usage for 12 months starting from current month (same one from ms project). How can split the hours between the start and finish date (equally does matter) for the projects so i can export it to an excel graph. cheers

[Prav]

anyone??

[RobDog888]

You would just run a query but split them how? By month, project ???

What office app is this going to be written in?

[Prav]

i'm using ms access 97 and excel 2000

[RobDog888]

You would just run a query but split them how? By month, project ???

How do you need it?

[Prav]

i have to export the monthly hours from ms access to excel to produce the graph.

[RobDog888]

But if you dont say how the query neeeds to be then it stops any help on the thread. Monthly hours totaled? Monthly hours by project? Only that months total? etc.

[Prav]

Sorry, Monthly Hours totaled for the next 12 months starting from current month.

[RobDog888]

How could monthly totaled for the next 12 months work? If you do a monthly total for current work done then how do you total hours for future work not performed yet?

[Prav]

a resource usage for 12 months starting from current month -
For example start date 01/01/07 , finish date 31/03/07 and the total number of hours is 150 hrs, for a project therefore i should get 50 hrs for Jan 07, 50 hrs for Feb 07, 50 hrs for Mar 07.

[RobDog888]

Oh so its more of a budgeting thing vs a timecard thing. Thats why I was confused about how to report on future hours worked lol.

So then you basically only need the budget hours returned from the database (50). Then when you are populating your report/graph you will generate a listing of months and set its point at the returned 50.

[Prav]

sorry about that... can you please explain more or point me to an example. cheers

[RobDog888]

There is no example for this type of custom technique you want. You need to take parts of each step and put it together.

First step would be to create a form in access with a couple of buttons. The write your query so when you click the button it will retrieve the "50" from your table with something like "SELECT Field1 FROM Table1 WHERE Field1 = 50;". Then create an instance of Excel and write those values to a range, add a chart, set its properties and display.