Thread: How to count text value from multiple columns

You can do it by changin the table using a recordset:

    Set rs = CurrentDb.OpenRecordset("your_Table", dbOpenDynaset)
        'Go to the first record.
        rs.MoveFirst
        'Loop through the recordset from first to last.
        Do Until rs.EOF
            intYesCount = 0
            intNoCount = 0
            intNACount = 0
            'Check the answer for the first question
            If rs!Q1 = "Yes" Then intYesCount = intYesCount + 1
            If rs!Q1 = "No" Then intNoCount = intNoCount + 1
            If rs!Q1 = "N/A" Then intNACount = intNACount + 1
            'Check the answer for the second question
            If rs!Q2 = "Yes" Then intYesCount = intYesCount + 1
            If rs!Q2 = "No" Then intNoCount = intNoCount + 1
            If rs!Q2 = "N/A" Then intNACount = intNACount + 1
            'Check the answer for each answer in the same pattern.
            '...
            '...
            '...
            'Put the found values into your total fields.
            rs!Total_Y = intYesCount
            rs!Total_N = intNoCount
            rs!Total_NA = intNACount
            rs.Update
        rs.MoveNext

If you haven't used recordsets before, find some info via Google so you understand how they work, they are handy when you can't use SQL.

If you set up your table differently, you could find your results using SQL.
If you changed your table to three fields:
App_ID; Question_ID; Answer
You could then use the count function in SQL, and specify the app with the WHERE clause to find totals by app. You could also use the count function and specify the Question_ID in the where clause to find the totals by question.