Calculating Multiple Checkboxes with If Statements

I have four different fields that are yes/no checkboxes in my report. The
fields are chk_firstAid, chk_physio, chk_FDvisit, and chk_SHMHvisit.
At the end of the report I will do a sum of all four checkboxes, however the
user wants me to set it up with a tricky multiple if statement that I can't
wrap my head around and actually don't even know if it is possible.
In each record one or all of the four checkboxes can be checked. For
different senarios the user wants the checkbox sums to total up differently.
For example if chk_firstAid and chk_physio checkboxes are both checked for
one record then I just want the chk_physio total to add one to the sum at the
end of the report and not add one for the total for chk_firstAid. Is this
possible and if so how can I code this?

Asked and answered somewhere else. Please don't multi-post



"Playa" wrote in message
...
I have four different fields that are yes/no checkboxes in my report. The
fields are chk_firstAid, chk_physio, chk_FDvisit, and chk_SHMHvisit.
At the end of the report I will do a sum of all four checkboxes, however
the
user wants me to set it up with a tricky multiple if statement that I
can't
wrap my head around and actually don't even know if it is possible.
In each record one or all of the four checkboxes can be checked. For
different senarios the user wants the checkbox sums to total up
differently.
For example if chk_firstAid and chk_physio checkboxes are both checked for
one record then I just want the chk_physio total to add one to the sum at
the
end of the report and not add one for the total for chk_firstAid. Is this
possible and if so how can I code this?

sorry thought that since it was a different section i could. But will not
double post in future...thanks for your help

"Rick B" wrote:

Asked and answered somewhere else. Please don't multi-post



"Playa" wrote in message
...
I have four different fields that are yes/no checkboxes in my report. The
fields are chk_firstAid, chk_physio, chk_FDvisit, and chk_SHMHvisit.
At the end of the report I will do a sum of all four checkboxes, however
the
user wants me to set it up with a tricky multiple if statement that I
can't
wrap my head around and actually don't even know if it is possible.
In each record one or all of the four checkboxes can be checked. For
different senarios the user wants the checkbox sums to total up
differently.
For example if chk_firstAid and chk_physio checkboxes are both checked for
one record then I just want the chk_physio total to add one to the sum at
the
end of the report and not add one for the total for chk_firstAid. Is this
possible and if so how can I code this?