form or query problem, not too sure

[Stuart Green]

I have a simple customer table that has a unique identifier for the customer. There is another "many" table where each time this customer is contacted they can either respond yes or no. This process only goes on for so long, then the customer unique record is notated as being closed through a closing form. What I would like to do at form level (any record possibly at table level) is show/record the total number of yes responses there have been for this customer during the period. I suppose what I want is to put some form of count in a query where the query is purely for the selected customer and base the closing form around this query but I'm not too sure if this can be done

 

[KevinM]

Use a totals query.

Set the criteria to show only 'true' records.

Include the customer id and name (optional) and then group by COUNT on the Yes/No field.

 

[Stuart Green]

Many thanks for the prompt reply Kevin, will give it a whirl