Display only some fields from each record based on specific criter

[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.

 

[Jeff Boyce]

If you are using one field per survey question/response, you have ... a
spreadsheet!

Take a look at Duane H's AtYourSurvey for an example of how a
well-normalized relational database handles surveys and tests...

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jmoore]

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.

 

[Jeff Boyce]

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

 

[KARL DEWEY]

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.

 

[jmoore]

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.

 

[KARL DEWEY]

I do not have only a spreadsheet.
Your table structure is that of a spreadsheet.

 

[Jeff Boyce]

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