Trouble querrying information for a report

[tom.hansen]

Last year I created a database to store results from an annual satisfaction survey. As is my usual m.o. when pinched for time, I didn't put much forthought into it as chances were good it was a one time assignment. The survey came and went and was forgotten. Now, a year later, I'm inputing this years survey data and would like to make improvements to steamline the process for whomever will be using the database in the future.

Originally, I created a report consisting of three charts for each survey question. Each chart I created in a form rather than directly on the report because I found it much easier to modify the chart in form design view. There are 11 survey questions. That's 33 forms with charts and 11 separate reports. I'm thinking there has to be a better way.

I would like to create one report, consisting of the three charts, based on a query with parameters for survey year and survey question. I've figured out the parameter for the year, but I'm at a loss as to how I can set it up to prompt the user for the field for the question number they desire.

Any ideas?

 

[PaddyIrishMan]

If you use [Please Enter a Question Number] as criteria for the question number field in your query, an Input box will be displayed prompting the user to enter the Question number.

Is this what you are looking for?

HTH,
Patrick

 

[tom.hansen]

Thank you for your reply Patrick.

I'm not sure. My table consists of the following:
Primary key
Survey year
Level of Care (Survey of health care facility)
Question 1
Question 2
and so on through question 11.

Would I [Please Enter a Question Number] as the criteria under each question number?

 

[PaddyIrishMan]

Hi Tom,
I didnt realise that you had a field for each question. This complicates the issue as it would require quite
a bit of work to combine them & update all of the archived data.
Because the data is coming from a different field for each question, you need to change the data source for the form each time the
user selects a different question. This will involve writing VBA code which I'm not sure if you're familiar with?
If you have time on your hands & want to consider a rewrite of the database I'll help you whatever way I can (Time allowing)

Regards,
Patrick.

 

[tom.hansen]

Thank you again for your reply. I am not familiar with VBA codes. As for rewriting the database, I'm willing to do whatever I need to in order to make it practical. I'm not sure how long I will be using it, so I want to make it as sensible and user friendly as possible for the next user. Also, with only two years worth of data or roughly 1000 records, now seems to be a good time to make it work. Any suggestions you have are greatly apprciated.

Thank you again,

Tom