Column Naming Too Long

  • Thread starter Thread starter Kaylen
  • Start date Start date
K

Kaylen

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!
 
I am designing a database consists of questions as column fields in a table.
Click to expand...

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!
Click to expand...

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.
 
Back
Top