query help

[buggy2]

I am looking to create a query which will categorise the amount stored in a table per rating.

if amount < 0% then set the category field to "Less than 0"
if amount >0% but <10% then set the category field to "between 0% and 10%"
if amount >10% but <20% then set the category field to "between 10% and 20%"

Note amount, rating & category are fields in the same table

 

[Joe4]

If you are looking to just return the phrase in a query, just create an expression in your query, something like:

expr1: IIf([Percentage]<0,"Less than zero",IIf([Percentage]<0.1,"between 0% and 10%",IIf([Percentage]<0.2,"between 10% and 20%","")))

If you actually want to update a category field, simply create an Update query, and use this expression in the "Update to" section of the category field.

Please note that you may need to change the "<" signs to "<=" in certain instances, depending on your needs (you didn't say what to do if the values were EXACTLY 0%, 10%, or 20%).