HELP

N

nizar.obeid

Hi,

I have a problem. I have a table that has all the projects with
project managers referenced to it. there is also start date and end
date of the projects. you can say it is a project tracker. i have
managed to generate a pivot chart to see the load on each project
manager (pm). Now i need to have the report display the information by
time wise. what i really mean, the user needs to check the current
week, current month or input the start and end dates.
the result will be, for the first one, current week, it will take all
the projects that are within this week for each pm regardless of its
status (whether the project is completed, active, on hold,.....).
the second, will be instead of a week, it will be month.
the last, if the user has inputed a start date and end date.
can you plz help?
thanks
Nizar
 
Top