In my query I have a table with StatusID and description. StatusID goes 1-17 and each one has a different description. How could i get this to say 1=this, 2=that,3=those,4=these and so on?
In my query I have a table with StatusID and description. StatusID goes 1-17 and each one has a different description. How could i get this to say 1=this, 2=that,3=those,4=these and so on?
I am not sure I understand. Are you trying to permanently change the values you currently have in for your description?
If there are only 17, you should be able to update those quite quickly.
I just want them to show up "labeled" in my query. Those values are fixed and will never change, but on our applications they will have one of those numbers. Instead of a number, i would like it to print the corresponding status.
Just create a "lookup" table that converts the values into the descriptions you want, and link that lookup table into your query and return the description.
Im not entirely sure on how to do that. Im pretty much an access noob
I know before i had an expression along the lines of IIf([statusId]=1,"this") if i tried to do that with all of them i would get different errors.
All you do is create a new table with two fields, StatusID and StatusDescription. Then add your 17 records (for each value). Then, link that table in to your query on the StatusID in your other field, and return the StatusDescription field.