I have a table, which allows a client name to be entered, and 4 check box fields to be assigned. Each check box needs to carry (somehow) a numeric value, in order to accumulate a total figure. E.g.
Field name Name box 1 box 2 box 3 box 4
Record J Smith v v v
Value 5 10 10 20
Required calculate total for this record equals 35. Any ideas on how to go about this would be gratefully received.
Thanks.
Field name Name box 1 box 2 box 3 box 4
Record J Smith v v v
Value 5 10 10 20
Required calculate total for this record equals 35. Any ideas on how to go about this would be gratefully received.
Thanks.