I have a number of forms and on each form there are a number of check boxes. I want to be able to add up how many check boxes read true. i.e if check1 = true then total = 1, if check2 = true then total now = two. Can I achive this?
No its not a continuous form. I need to count the number of records that have a true in the tick box. I know I need to use one of the count functions just not sure which one as i belive there are a few.
No its not a continuous form. I need to count the number of records that have a true in the tick box. I know I need to use one of the count functions just not sure which one as i belive there are a few.
Does not matter if the form is continous or not. Use the DCount() function to count the number of "true" check boxes. You must use criteria to tell the DCount() which table to search and which field you want to count the number of true's [remember to use the -1 as your "true" criteria].
Search the Access help file for the DCount() function for examples and more info.