I have a table that shows up on my report with a number 6 or number 7. On the report when the numbers come up I want them to show as words, IE 6 would be "sunshine" and 7 would be "gloomy".

This is what I've been working on. Is there a way to do this? Would somebody be able to help me with the formula?

if {table1.table1} = 6 then "sunshine" else "gloomy"

Thank you.

Thank you for your help DBlank.

Edited by belfane - 05 Jun 2014 at 3:32am