If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column Naming Too Long
I am designing a database consists of questions as column fields in a table.
My problem is that since the coulmn fields are the the questions, the questions are very lengthy and won't fully fit in the column headings in the table. I tried naming the columns by numbers but then when I export the data onto excel, I can only see the numbers as columns headers and my goal is to be able to see the whole question in the column heading instead. Any ideas on how to solve this problem? Thank you! |
#2
|
|||
|
|||
Column Naming Too Long
On Mon, 22 Dec 2008 12:04:03 -0800, Kaylen
wrote: I am designing a database consists of questions as column fields in a table. Then you are making a VERY BIG MISTAKE. My problem is that since the coulmn fields are the the questions, the questions are very lengthy and won't fully fit in the column headings in the table. I tried naming the columns by numbers but then when I export the data onto excel, I can only see the numbers as columns headers and my goal is to be able to see the whole question in the column heading instead. Any ideas on how to solve this problem? Thank you! Use a normalized data structure with one question per *RECORD* rather than one question per *FIELD*, in a table related one to many to your main table; and use a Crosstab query with the question field as the Column Header for your export to Excel. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Column Naming Too Long
Can you give me more detailed direction with this?
"John W. Vinson" wrote: On Mon, 22 Dec 2008 12:04:03 -0800, Kaylen wrote: I am designing a database consists of questions as column fields in a table. Then you are making a VERY BIG MISTAKE. My problem is that since the coulmn fields are the the questions, the questions are very lengthy and won't fully fit in the column headings in the table. I tried naming the columns by numbers but then when I export the data onto excel, I can only see the numbers as columns headers and my goal is to be able to see the whole question in the column heading instead. Any ideas on how to solve this problem? Thank you! Use a normalized data structure with one question per *RECORD* rather than one question per *FIELD*, in a table related one to many to your main table; and use a Crosstab query with the question field as the Column Header for your export to Excel. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Column Naming Too Long
On Mon, 22 Dec 2008 14:40:00 -0800, Kaylen
wrote: Can you give me more detailed direction with this? There's an excellent questionnaire demo application available at Duane Hookum's "At Your Survey": http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000' Also consider Roger Carlson's Training Registration database: http://www.rogersaccesslibrary.com/d...gistration.mdb -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Column Naming Too Long
Is there a way to have a hyperlink that opens to show a specific record on a
form? "John W. Vinson" wrote: On Mon, 22 Dec 2008 14:40:00 -0800, Kaylen wrote: Can you give me more detailed direction with this? There's an excellent questionnaire demo application available at Duane Hookum's "At Your Survey": http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000' Also consider Roger Carlson's Training Registration database: http://www.rogersaccesslibrary.com/d...gistration.mdb -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|