Solved: Graphing Question

[jauner]

Not sure if this can be resolved by VBA but here goes:

I have a database that I have been asked to write the reports on. The original database design was not mine and has to stay the same.

They want a graph of a count of questions answered. There is a table called tblAssessment that contains the questions. the fields are question1, question2 etc through question10. Is there a way to graph these? I am new to writing graphing reports In access. I would think each field would be considered a series and unsure how to proceed exactly.

If that is too many is there a way to write the query in such a way that each question is like a row in the query vs individual fields?

[matthewspatrick]

I have a database that I have been asked to write the reports on. The original database design was not mine and has to stay the same.

I know you said you can't change it, but are you sure? I ask, because that is a really bad design :eek:

Patrick

[jauner]

Yes unfortunately I am contracted but the contract did not include database redesign only the changes. Would really love to fix the design.



I did find a creative way to fix my problem. I wrote some VB Code that basically goes through the record and puts them into a table so I can graph the data I need.

[matthewspatrick]

Glad to hear you got it figured out. Don't forget to mark the thread as solved...

Patrick