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

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

You can't do that at table level. You would need to use a form or an update query. Personally, I think you should use the form. Nobody should work in the tables directly anyway, so you should provide a form interface and there is where you can have code to update one field based on the input of another.

So can I make the form/query write the solution to the if/then back into the table. ANy pointers on how to do that. Sorry I'm new at this stuff.

Create a Form Based on your Table, and In the After Update of the First Field, add an If() condition that updates the Second Field with the value that you require. When the Form updates, the field will have the value that you want.