Counting Entries by Date

[Adam_Balcomb]

Hi there. I currently have two tables. My {School} table includes a column called “Age Group” which is a Multiple select field. This field provides the selection options of Pre-School, Year 1, Year 2, Year 3 etc.

I have another table called Statistics with a rollup linking back to the “Age Group” field in my {Schools} table.

I want to create a rollup or other formula that looks at all the schools from Bedfordshire, then counts to see how many of them have “Year 1” etc selected in the Age Group field. This to then be displayed as a total.

Any help would be greatly appreciated.

[Adam_Balcomb]

OK so I think I see where the problem is. The Age Group is a multiple select option not single select. If it were single select the formula **

IF({Age Group}=“Year 1”,1,0)

** would work perfect. How can I set this formula to work if “Year 1” has been included regardless of what other years have also been selected?