Hi,

I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions, add more questions later.

Any suggestion would be much appreciated