Count function in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in the process of creating a survey database.
For each field (question asked on the survey) I need to return
1. the total number of responses for that field (the fields are text fields)
2. the number of responses that are “Very Satisfied†(displayed as a number),
3. the number of responses that are “Very Satisfied†(displayed as a
percentage.
I have tried using the count function in the total row. However, it not
returning the results that I expected

Thanks for any help you can provide
 
Sure,
I have 3 tables:
1) a response table that I use to look up the values for the survey
responses. The chosen value is saved in my survey table.
2) The Survey table contains the responses to the questions as well as a
client ID and survey ID (both auto number fields).
3) Client table that contains info about the client (address, contact name,
etc)
The client ID is the primary key in the client table, and the survey ID is
the primary key in the survey table (This is how they are related).
I hope this is the info you needed.
Thanks for taking the time to help
 
Back
Top