I have a database with questions where the user can respond
How do I count how many have responded never, how many responded sometimes how many responded usually and so on? I created a query with the first field as a calculated field. Here is the criteria:
Qlty of Sup1: DCount("[COMPANY]","tblquestionaire","[onea]=1 and [location]='" & Forms!Loc!cboLocation & "' ")
As you can see I am using query by form. The form for this query has one field I am filtering by. I don't know how to add multiple fields to the criteria. I will have to let the user filter by Location, Division, Supervisor and a date range.
I need help modifying the statement so that I can filter and count by multiple fields. Thank you!
Assuming your [onea] value represents the response and it's numeric then I can't see a problem with your statement - are you saying there is a problem? Are you asking how to include further criteria ? If so just continue the criteria bit as you have already done.