Acquiring a total figure

[RAClarke]

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.

 

[PHV]

Something like this ?
Abs(5 * box1 + 10 * box2 + 10 * box3 + 20 * box4)

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RAClarke]

That was just what I was after, thanks very much!!