Pass Field Name to Query from Input Box

From: Rick Baker (rwbaker1_at_swbell.net)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 02:48:33 GMT

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