I'm sure this is a very simple calculation but I need some help. I wish to add up the values in a field on a form. =[field1]+[field2]+[field3]+[field4]+[field5]. Easy enough but what I would like is that if the values of the 5 fields is greater than 20 for it to default to 20. Does anyone have any idea how I would write this equation?
Thanks for any help that I get.
Brad