Will do! Thanks for the reminder

The code I showed was missing and "end" and a ")".

But was suggested to me that I would use this instead, and it works great!

Link

In case someone else needs...

Hi there, pietlinden.

No, I'm not using SSRS. I will need these values for some reports in the future but for now I'm just creating the columns and their calculations as...

Thank you for your reply Crow, I'm trying to solve the more complex ones first and see if I can get around the only field that needs to be calculated...

• This reply was modified 5 years, 3 months ago by  whoopcg.

Thank you for your help, Scott

Worked like a charm! Sorry for the late feedback but I was away.

So, in a more complex field, where if C="WORD":

• A = 51 if...

• This reply was modified 5 years, 3 months ago by  whoopcg.