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
|
|||
|
|||
How do I display the totals for yes/no responses in a report?
I am producing a report from a database set up to record the responses from
questionnaires. Most of the questions are graded 1 to 5, so its easy to show an average value; however, on the same questionnaire I have also got yes/no responses (saved as 1 & 2 respectively). Instead of producing an average value, I would like to show the total number of replies for each question (e.g. 5 yes and 4 no). Many thanks if you can |
#2
|
|||
|
|||
How do I display the totals for yes/no responses in a report?
Markymark wrote:
I am producing a report from a database set up to record the responses from questionnaires. Most of the questions are graded 1 to 5, so its easy to show an average value; however, on the same questionnaire I have also got yes/no responses (saved as 1 & 2 respectively). Instead of producing an average value, I would like to show the total number of replies for each question (e.g. 5 yes and 4 no). Many thanks if you can Number of Yes responses... =Sum(IIf(FieldName=1,1,0)) Number of No responses... =Sum(IIf(FieldName=2,1,0)) -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
help needed | jkendrick75 | Running & Setting Up Queries | 19 | March 17th, 2005 02:37 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |