Results 1 to 7 of 7
  1. #1
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56

    Renaming values?


    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?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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.

  3. #3
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    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.

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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.

  5. #5
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    Im not entirely sure on how to do that. Im pretty much an access noob

  6. #6
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    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.

  7. #7
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Renaming Reports issue
    By djclntn in forum Reports
    Replies: 4
    Last Post: 01-06-2012, 03:46 PM
  2. Renaming a report before SendObject
    By kingdoz in forum Reports
    Replies: 2
    Last Post: 11-17-2011, 08:22 PM
  3. Renaming Utility
    By bginhb in forum Access
    Replies: 3
    Last Post: 11-02-2011, 03:11 PM
  4. Renaming a file using VBA
    By bfaucher in forum Programming
    Replies: 1
    Last Post: 11-01-2011, 02:56 PM
  5. Renaming fields
    By WilsonsW in forum Access
    Replies: 10
    Last Post: 03-25-2011, 01:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums