I have two dates for an activity, a start date and an end date. I would like to create a report which lists the activities on the left and then uses a horizontal timescale indicating which activities are active in which month, in a similar way to a gantt chart in MS Project. How do I go about creating the timescale and spreading the dates across it?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Timescales in Access VBA
- Thread starter JohnLanc
- Start date
Hi
You could maybe create a temp table that contains a row for each day between start and end date and then outer join that table in a cross-tab query.
I did a similar thing but in SQL Server, and it seemed to do the trick!
Good luck!
Rob
You could maybe create a temp table that contains a row for each day between start and end date and then outer join that table in a cross-tab query.
I did a similar thing but in SQL Server, and it seemed to do the trick!
Good luck!
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question