Quick and dirty response. You'll need to adopt this to your own usage.
SumVariable = SumVariable + CDbl(IIf(InStr(1,[FieldName],"<") > 0, Mid([FieldName],InStr(1,[FieldName],"<") + 1),[FieldName]))
If the above isn't exactly right, see help on the InStr, Mid, and IIf functions.
If you...