Text Box Formula Help

[Neo-fite]

Of the several fields that I have on a report, I have 2 that I am concentrating on...1 is "Quarter" and the other is "Month1".

I am trying to have the Month1 label appear as "January" if the rightmost character in "Quarter" is a 1.

I suspect this is fairly easy, but I haven't had any luck coming up with the formula.

Thanks in advance

 

[Trevor G]

You should be able to use and IIF formula, something like this

=IIF(Right([FieldName],1)=1,"January")

Not tested. But look at IIF and also Right in the formula Help.

 

[Neo-fite]

Expanding on that idea...

=choose(Right([Quarter],1),"January","April","July","October")

AWESOME! Thanks!

 

[Json]

Sorry for digging up a resolved post but have you thought about this from a different angle?
What about how you store the information?
I am not explaining myself well
Try the attached... you could ditch the formula completely.