Rounding and expressions

[Ximena]

Hi im working in a document and this are the instructions but I have no idea how to write the expression or where to write them! can someone help me please

Open the Rounded Prices query in Design view. 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.



IGNORE THE TWO LAST COLUMNS

[JoeM]

Hello. I don't think that you are going to find anyone to do your homework for you, however we will point you in the right direction.
Here is an article on creating Expressions/Calculated Fields in Access.

With a Google search, you can find information on almost anything, including Expressions, Round function, etc.