Ok I do not know if my title is ok for what I am asking about. I am trying to take a list of mileages and mark them as a certain category. So here is some examples:
These mileages
35833
39861
35107
59933
48913
20197
Have to fall into these categories:
24000
36000
50000
60000
So the mileages are each a separate record and in the column next to it I want to have one of the categories. So for the first one the record is 35833, the column next to it should show 36000.
Let me know if this is possible or should be through a Query.
Bookmarks