As far as the 255 character limitation, you might consider upgrading to
something like SQL Server or Oracle. They can handle thousands of characters
in a field.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"shm135" wrote:

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
.