I have an option group which gives the user the choice of whether a building is in use or not. The answers are stored in the table as 1 and 2. The subform, with the option group, has the record source as a query. I have tried to put the count calculation in the query but the subform wont then let me add another record. I know it is possible to count the instances of 1 and 2 in the control source of an unbound field on the subform but cant remember how, can someone please give me a hint?
