Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
If anyone could help I'd be very grateful.
Basically I want to calculate a new numeric field based on 2 text fields.
The text fields are limited to 3 choices eg: '0. None', '1. Low', '2. High'. They are a mix of numeric code and text decriptor and I'd like to keep these as text fields in this format to 'explain' the values for those entering data.
Want to compute a new 'Total' field which is the sum of the numeric codes of the 2 text fields. eg. '0. None' in field1 and '1. Low' in field2 = 1 in 'Total' field.
Thought about macros and querys but I'm stuck. Easiest and most automatic way to do this?
Many thanks in advance.
=Val(Left([field1],1)+Val(Left([field2],1)
Many thanks Muddy_bum: that's great and saved me loads of time