Table field length limit alternative
in [Tables]
|
From: shm135 on 15 Mar 2010 18:49 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
From: Gina Whipp on 15 Mar 2010 18:56 shm135, Have a look at... http://www.rogersaccesslibrary.com/forum/forum_posts.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" <shmoussa(a)gmail.com> wrote in message news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... 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
From: Steve on 15 Mar 2010 19:40 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" <NotInterested(a)InViruses.com> wrote in message news:eicc3KJxKHA.5936(a)TK2MSFTNGP04.phx.gbl... > shm135, > > Have a look at... > > http://www.rogersaccesslibrary.com/forum/forum_posts.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" <shmoussa(a)gmail.com> wrote in message > news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... > 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 >
From: Gina Whipp on 15 Mar 2010 20:01 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" <notmyemail(a)address.com> wrote in message news:#1#tUjJxKHA.1548(a)TK2MSFTNGP02.phx.gbl... 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" <NotInterested(a)InViruses.com> wrote in message news:eicc3KJxKHA.5936(a)TK2MSFTNGP04.phx.gbl... > shm135, > > Have a look at... > > http://www.rogersaccesslibrary.com/forum/forum_posts.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" <shmoussa(a)gmail.com> wrote in message > news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... > 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 >
From: John... Visio MVP on 15 Mar 2010 20:07 Gina, it is futile having a battle of wits with an unarmed opponent. Leave stevie to his delusions. John... "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:OH34HvJxKHA.812(a)TK2MSFTNGP06.phx.gbl... > 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" <notmyemail(a)address.com> wrote in message > news:#1#tUjJxKHA.1548(a)TK2MSFTNGP02.phx.gbl... > 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" <NotInterested(a)InViruses.com> wrote in message > news:eicc3KJxKHA.5936(a)TK2MSFTNGP04.phx.gbl... >> shm135, >> >> Have a look at... >> >> http://www.rogersaccesslibrary.com/forum/forum_posts.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" <shmoussa(a)gmail.com> wrote in message >> news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... >> 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 >> >
|
Next
|
Last
Pages: 1 2 Prev: How do I include more Help options for really inexperienced users? Next: Help with database |