I need an if then formula in Access

[tmccasland]

So I have an excel sheet with a complicated if then formula that I have tried to make work in access but it wont sadly. So with help we as in he has done most of it for me. We have hit a snag though. I need one column to pull letters out of another column and assign them numerical value. For example "w" is "5", "gs" is "3", "c" is "2", and "ru" is "1". in my excel sheet I could only put one of each numerical value. In Access I would like it to be infinite. No matter how many "w's" it is "5" per. can anyone help me with this dilemma.
thank you in advance

[June7]

Are there only those 4 alpha patterns? What happened to number 4?

Perhaps nested Replace()

Replace(Replace(Replace(Replace([fieldname], "w", 5), "gs", 3), "c", 2), "ru", 1)

If you need more help, show example data and desired result.

[tmccasland]

Thank you so much that worked great, it turned our w into 5 etc. Unfortunately one step forward and one back. If I have more than one reward such as W W it returns 5 5 instead of 10 in the box. Is there an easy way to turn multiple numbers in one field into a total sum number? 5 4 1 into 10. Thank you

[June7]

With VBA custom function.

[CJ_London]

it is not clear to me exactly what your reward string looks like but this will add your values together

?eval(Replace(Replace(Replace(Replace("wwgsru", "w", "+5"), "gs", "+3"), "c", "+2"), "ru", "+1"))
14

[orange]

tmccasland,

How about showing readers some sample "patterns", and
your desired output from these?

It would be easier to assist/advise you, if you would provide some sample data (input and expected output).

[June7]

Ahh, I forgot about Eval() function, nice!