how to use IF then statement

[ronnie4]

I have a column in my table that has a numerical value. I want another colum in that table to display "small", "medium" or "large" depending on the numerical value in the other column. How would I do this? Can I put in a code into the table or do I do it through design view?



Thanks

[tzh1600]

To display "small", "medium" or "large" in a forms