hi
if i have 4 fields (quarter1-4) of data type text - how can I sum or average these 4 fields from a command button on a form?
e.g. quarter1 may be 50%
quarter2 50%
quarter3 75%
quarter4 100%
if I wanted the average I'd want the result 68.75
thanks
tim
if i have 4 fields (quarter1-4) of data type text - how can I sum or average these 4 fields from a command button on a form?
e.g. quarter1 may be 50%
quarter2 50%
quarter3 75%
quarter4 100%
if I wanted the average I'd want the result 68.75
thanks
tim