Results 1 to 3 of 3
  1. #1
    rjohnson is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    2

    Need a function to change queried text

    Hello all,

    I am writing a query that is pulling in data from a column labeled "Priority". What I need help with is one of the common values returned from this column is "Normal". What I need it to say is "Routine" where ever it comes in as "Normal" in my query results. I was looking at the 'Format' function but it seems to be only for dates. I cannot use an Update query because I don't have the rights to update this table.

    I also use SQL developer and know about the to_char function but that also seems like it's only for converting date formats.



    Does anyone know of a function that I could use to do this? If this is confusing I'll try to explain it a different way.

    Thank you,
    rjohnson

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    SELECT iif(Priority = "Normal","Routine"), other fields here separated by commas
    FROM Tablename

  3. #3
    rjohnson is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    2
    Awesome. Thank you. Worked great.

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

Similar Threads

  1. Add selection to queried combo box
    By davefrag in forum Forms
    Replies: 1
    Last Post: 01-18-2012, 04:26 PM
  2. Replies: 20
    Last Post: 09-06-2011, 12:39 PM
  3. Replies: 1
    Last Post: 07-15-2011, 11:00 AM
  4. Using function to track change through months
    By Accessuser in forum Programming
    Replies: 8
    Last Post: 09-28-2010, 04:09 PM
  5. Replies: 1
    Last Post: 03-18-2009, 12:30 AM

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