View Single Post
  #4  
Old March 16th, 2010, 12:01 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table field length limit alternative

Steve,

Please grow up... either assist or move along.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
...
It's a good thing this wasn't a question about time! You might have said the
change to Daylight Savings Time changes time by 60 seconds.



"Gina Whipp" wrote in message
...
shm135,

Have a look at...

http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"shm135" wrote in message
...
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