Results 1 to 3 of 3
  1. #1
    mdnikki is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2012
    Posts
    63

    Using an update query to change a title from Dr. to Doctor

    I will try to better explain this. Our table has addressee and salutations. And we are trying to use an update query to fix this.



    Currently fields in our table look like this:
    Addressee: Dr. and Mrs. Charles Smith
    Salutation: Dr. and Mrs. Smith

    We would like to update those fields so they spell it out and actually say Doctor, replacing the Dr. with Doctor.

    We would like the fields to appear like ths:
    Addressee: Doctor and Mrs. Charles Smith
    Salutation: Doctor and Mrs. Smith

    I tried this with a like Dr.* just in case the Dr. isn't in the beginning of the salutation but this isn't working as sometimes we may have another title such as Cmdr. it updates that do Doctor as well.


    I know this is a simple fix but I can't remember how it is done.

    We are trying to update this using an update query. Any advice is helpful.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,682
    Working in a test database, you could try
    ....
    Addressee = Replace(Addressee,"Dr.","Doctor")
    same set up for Salutation

  3. #3
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    I would just do a simple Find and Replace on the column in your table, replacing "Dr." with "Doctor".
    Just be sure to set it to only look in that particular field, and tell it to Match "Any Part of Field".
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

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

Similar Threads

  1. Change generic colour in Title on Form
    By mortonsafari in forum Forms
    Replies: 2
    Last Post: 03-20-2016, 06:11 PM
  2. Replies: 7
    Last Post: 02-23-2014, 06:06 PM
  3. Change chart title with code
    By Pastor Del in forum Reports
    Replies: 6
    Last Post: 02-11-2014, 08:56 PM
  4. Cannot change column title
    By Ancient Dragon in forum Access
    Replies: 3
    Last Post: 11-12-2012, 08:44 PM
  5. Replies: 2
    Last Post: 05-26-2012, 01:08 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