Report as "chart"?

[VictoryHighway]

Hello. I'm trying to create a project management database and I need some help trying to figure out a way to do something specific. I want to create a report that has a list of current projects on the left, and has a "map" to the right of that. Up above that is a list of tasks (that are stored in a table called Tasks). This would form a chart and in each "block" of the chart there will only be one control (a checkbox that shows whether the task as above was completed or not.)

However, I'm finding it dificult to accomplish this. I have a tabled called Tasks, which lists all tasks required to complete the project, a ProjectList table which shows all current projects, and a Projects table which contains the information such as, The Project (as a reference to Projects Table), The Step (refers to Steps table), The Task (refers to the Task table), the planned and actual completion dates and finally, a yes/no field that indicates whether or not the task was completed. This produces multiple entries for the same project.

What I'd like to do in the report is to have one line-item per project and have multiple checkboxes that refer to different records.

Does anyone have any ideas on how to go about doing this? If you need more information as to how my database is set up, please reply to this message and I'll try to give you the information that you need.

Thanks in advance for your help.

--Geoffrey

 

[dhookom]

This sounds like a crosstab query should work. Is the task list static for all projects or are they all unique? There are some sample crosstab reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

These samples might be overkill if you will always know the list of possible tasks.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[VictoryHighway]

Duane,
Yes, I had come up with the same conclusion myself after thinking about it. I'll let you know how it works out.

Thanks,
Geoffrey