Multiple Parameter Queries and Reports

[Guest]

This maybe complicated, but I've received great help from here...

I have a DB with two tables, 1 for the location the survey was administered,
and 1 for the surveys from that location. I've related the tables and created
an appropriate form and now am trying to create a summary report. I want to
be able to count the # of questions wrong, # right, %, etc. More importantly
i need to be able to do this by a selected location. I successfull created
queries for all the questions, counting correct/incorrect, but now i am stuck
with figuring out how to ask the location. I can add in parameters to the
query to ask for the teacher, but that doesnt seem to be the answer to create
the report i mentioned above, aside from changing the location for each query
(15 for correct and incorrect).

A side, but related question - can you created a parameter query that will
apply the selection to many queries at once?

Any input will be helpful i am sure, and please let me know if you need
clarification.

Thanks,

 

[Guest]

Hi blackbiscuit8,

What you want to do is create a form, say it's called frmReports, and have
controls on that form that your queries use to grab the parameter from, eg: a
combo box full of locations, call it cboLocation. You could then have the
following in the criteria for your query under LocationID (or whatever the
appropriate field is)

forms!frmReports.cboLocation

That way you can use the combo to select a different location and run the
query again, hey presto different results!! Of course you need to set up
your 15 queries first, but then it's plain sailing.

Hope this helps.

Damian.

 

[Guest]

Damian - Thanks for the suggestion. I follow the logic. Combo box picks the
value for the query. Im having a little difficulty still. Do i need to have
the combo box on a form by itself and the queries on a report, or you
suggesting the form to have the combo box, and the queries, with the results
as my "report". I think im having trouble tying it all together, as when you
pick from the combo box, everything seems to sit there. Thanks again,