Hi everyone, I am using access 2010.
I have a field called April 2011, it is a Yes/No tick box. I have created a report with this field in and I wanted to sum all of the ticks (Yes answers). I searched online and found this; =Abs(Sum([April 2011])) but I just get an error (I am using a text box and inputing this formula into the control source). does anyone know why this oesnt work?