By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Gantt Charts in Access

P: 5
Hi Guys, my first post.

I've been doing alot of "googling" for a way to make Gantt charts as an Access report. I am aware of what MS Project and Visio do and also aware of other programs out there that can feed off MS Access Data.

The data set up is as follows:

There are a list of courses which have a start date and a duration (in weeks) giving an effective end date. Each course is assigned to a location - of which there are 12 locations and around 100 courses to each location - on a many-to-one basis (i.e a course can only exist at one location but a location can have many courses)

Any tips would be appreciated as i've been banging my head against a wall on this for ages. I keep trying to use MS Chart thingy but it never seems to display any of my data.

I am using Access 2007 and the data i want is generated via a Query.

Thankyou all very kindly in advance

Jan 11 '08 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,357
so... Are we talking 1200 bars?
Jan 11 '08 #2

P: 5
Hi Dude,

no, not 1200 bars per chart - but 12 charts of which there are around 100 bars on each. Basicallyt i need to generate a Gantt chart for each location displaying when courses are taking place - so they can make a big poster of it and stick it on their wall!
Jan 22 '08 #3

Expert Mod 10K+
P: 12,357
Well, assuming you just need a timeline thing and don't need to show dependencies between the different tasks, I suppose you could create a bunch of colored rectangles in a report and use code to populate everything; Preferably with a loop of some sort.
Jan 22 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.