Access 2013

[roseline]

Create a new column to round the Retail price of each item to the nearest dollar. Name the field RoundedRetail. Create a new column to display Luxury for all items that have a RoundedRetail value of $100 or more and Everyday for items that are less than $100. Name the field Class. Run the query. Save and close the query. what will it look like.. just confused on what the expression will look like

[June7]

Do you have an issue? Ask a question.

[roseline]

Yes, the question is what will the expression be?

[June7]

You mean the expression for the Class field?

IIf([RoundedRetail]>=100, "Luxury", "Everyday")