I am trying to figure out a workload report.
If there are 3 projects:
A: from 12/31/02 - 05/01/03
B: from 02/01/03 - 02/09/03
C: from 02/01/03 - 09/10/03
I want to show a workload report that shows each month and then indicates if that project is occuring within that month.
How would I ask it to look at a range and then indicate if it falls within a specific month and if so, to mark it with an X or a 1 or whatever.
I have done this before in Brio and it was quite simple because the formatting is quick and dynamic (and it uses extensive pivot reports) - but I am unable to determine how to do this in Access.... :-/
Thanks!!!
Lisa
If there are 3 projects:
A: from 12/31/02 - 05/01/03
B: from 02/01/03 - 02/09/03
C: from 02/01/03 - 09/10/03
I want to show a workload report that shows each month and then indicates if that project is occuring within that month.
How would I ask it to look at a range and then indicate if it falls within a specific month and if so, to mark it with an X or a 1 or whatever.
I have done this before in Brio and it was quite simple because the formatting is quick and dynamic (and it uses extensive pivot reports) - but I am unable to determine how to do this in Access.... :-/
Thanks!!!
Lisa