I have a table, where each row represents a survey given to a sample of doctors. There are 45 surveys. I want to be able to run a query that essentially returns the surveys that contain a specific question (since many of the questions are recycled). Every survey has 180 questions.

I'm just now trying to put all the data into an access (i use 2007) database so this process is easier. I have a table with the following columns: SurveyID (PK), SurveyDate, NumSurveys, Questions (FK).

I have a separate table for every question ever included in the surveys - each question has its own ID. In the "Surveys" table want to be able to include all 180 questions given in the survey in one column (Questions). Can/how/should I use an array to do this? Can I change the data type for the column to accommodate an array?

Alternatively, could I make 180 columns, each representing one question? How would that work? The problem I run into there is running the query in an efficient manner