Display only some fields from each record based on specific criter

  • Thread starter Thread starter jmoore
  • Start date Start date
J

jmoore

The data fields I am working with are CountyName, ID, and more than 30 fields
(question responses).

I am trying to create a report for each county (CountyName), grouped by ID.
Under the ID, I want to show the Quest#, and Answ when the response (Answ) to
the question is a certain value (e.g., 2 or 3), and not display if it was
answered differently.

Example:
ID#999
Quest#1 Answ 2
Quest#6 Answ 3
etc. (where questions 2-5 were answered correctly and do not need to be
listed.)

Thanks so much for any suggestions.
 
Thanks for the quick reply. However, I do not find the answer in
AtYourSurvey. I can create a list like the IndividualSurveyReport. But I
want a question and response included only when there is a specific answer.
My field, ID, corresponds to the Respondent that I want to group on. My list
below the ID would be similar to the example, except some questions would be
skipped.

Again, thanks for suggestions.
 
My previous response pointed out that your data structure is suitable for
spreadsheets, but not for a relational database.

If you want to get good use of Access' features and functions, you can't
feed it 'sheet data. One column per question/response is 'sheet data.

AtYourSurvey provides a way to normalize your survey/questionnaire.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I do not find the answer in AtYourSurvey.

Jeff Boyce response was for you to not use your spreadsheet but the database
as laid out by Duane H's AtYourSurvey.
 
I do not have only a spreadsheet. I have related tables that are queried to
create the report. I do not want to display the data as a spreadsheet. I
want to only display a record when the response matches different criteria.
 
Here's why I assumed you are working with a spreadsheet-like table:

[Question#1] [Question#2] [Question#...]

This is how data might be organized in a spreadsheet.

This is NOT a well-normalized table structure in a relational database.
Access "expects" well-normalized data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top