Pass Field Name to Query from Input Box

[Rick Baker]

The db is a table of survey results where people completed a survey with
name and placed a check beside numbered statements indicated "I am
interested in ..." The check boxes are in a field named 1, 2, 3...66. So
the field name matches the area of interest on the survey. The data type is
Yes/No.

I want a query that will prompt me to input the area of interest number
(field name) and return all the names that checked yes for that area of
interest.
tblSurvey_Results
FName LName 1 2 3 4
John Doe X X
Jane Smith X X

If I enter "2" in the input box, both names should be returned.

How do I get the field name from the input box to the query? Is there a much
simpler way to accomplish this result with a different table design?

Thanks,
Rick

 

[Duane Hookom]

You table isn't normalized. Consider the sample "At Your Survey" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. I would
suggest you create a union query based on your table but I don't think
Access would support 65 UNIONs.

If you are stuck on your current structure, you might need to use code to
modify the SQL of a saved query.