Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How would I code a date range that spans several months by month

Status
Not open for further replies.

lmn

Programmer
Apr 3, 2003
60
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top