Think of the "answer d", "answer e", etc. as "part d of question 2", "part d of question 2", etc. Each "part" requires a separate answer/response.
Here is the actual question #2 (w/ some slight reformatting to make it fit in the grid below):
2. How many months have you been filing your...
Just to let you know, based on the sentence "The limit of 255 fields can be breached if you add and then delete fields without compacting" I resolved the issue with saving the updated table design. I compacted/repaired the database and then added the new columns. The updated design was then...
In my example, "Q2d_z" corresponds to all of the people that responded "Never" for "Sample question 2 - answer d". "Q2e_z" corresponds to all of the people that responded "Never" for "Sample question 2 - answer e". And so on. The actual survey has 7 columns and 8 "answers" (or 56 fields) on...
Thank you for your quick response.
However, I don't believe I did a very good job of describing the desired report. The fact that this report is based on a survey is mostly irrelevant. The problem is more general in that I have multiple records with values that need to be placed in certain...
I would like to fill in values onto a report based on the rows in a table. Each field on the report will have the value from a column in the table when the value of another column equals a predetermined value.
For example, the table has two columns:
question_id
question_count
The report has...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.