B
bassplayer
Hi
I have a database of about 800 entries (still climbing). Due t
changes at work i now have to keep count of the amount of check boxe
which equal true on a form. The form has about 8 checkboxes so i nee
to know how many entries have one box ticked, how many have two an
so on. I have managed to get this to work on new entries by using a
if then statement to keep count in an unbound textbox but it doesn
seem to work on the 800 entries made before the changes wer
implemented. Is there a way to 'refresh' the database so that the i
then statement works for the previous entries? Any help would b
greatly appreciated
I have a database of about 800 entries (still climbing). Due t
changes at work i now have to keep count of the amount of check boxe
which equal true on a form. The form has about 8 checkboxes so i nee
to know how many entries have one box ticked, how many have two an
so on. I have managed to get this to work on new entries by using a
if then statement to keep count in an unbound textbox but it doesn
seem to work on the 800 entries made before the changes wer
implemented. Is there a way to 'refresh' the database so that the i
then statement works for the previous entries? Any help would b
greatly appreciated