Results 1 to 5 of 5
  1. #1
    GUMUBIBI is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2009
    Posts
    6

    Update query help!!!

    Hi



    I'm trying to make an update query for multiple data and no success. The problem is this.

    Names
    Agent mary
    ag. roger
    agentus jhonny
    ca. mary
    ca. roger
    ca. jhonny

    I want to transform ca. mary in agent mary, ca. roger in ag. roger, ca. jhonny in agentus jhonny in a single update query.

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Questions:

    Do all the values want to change prefix with ca. ?

    How many time will roger, mary, etc appear in the table?

    Will they only have one name, eg: Roger, Mary, jhonny?

    Answer the above and then I may be able to offer a solution.

    David

  3. #3
    GUMUBIBI is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2009
    Posts
    6
    Quote Originally Posted by dcrake View Post
    Questions:

    Do all the values want to change prefix with ca. ?

    How many time will roger, mary, etc appear in the table?

    Will they only have one name, eg: Roger, Mary, jhonny?

    Answer the above and then I may be able to offer a solution.

    David
    Yes, all the values want to change prefix with. ca. The names can apear unlimited depending on the period I choose for sales. No they will have 2 names.

  4. #4
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    How is the data getting into the tables in the first place? I suspect you are importing the data from elsewhere.

    What you need is a table that has the user names with their default prefixes in. Then oyu can use the replace function to swap out the incoming with the default at point of input.

    David

  5. #5
    GUMUBIBI is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2009
    Posts
    6
    Quote Originally Posted by dcrake View Post
    How is the data getting into the tables in the first place? I suspect you are importing the data from elsewhere.

    What you need is a table that has the user names with their default prefixes in. Then oyu can use the replace function to swap out the incoming with the default at point of input.

    David
    Yes

    This is true. I never thought of that. I was so focused on the update query that I never thought of a join situation. I'll try it. Thanks

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

Similar Threads

  1. Update Query
    By Najeeb in forum Queries
    Replies: 1
    Last Post: 11-19-2015, 04:02 AM
  2. Help with update query
    By weirdg in forum Queries
    Replies: 0
    Last Post: 09-03-2009, 04:21 AM
  3. Need help with an Update query ...
    By valkyry in forum Queries
    Replies: 0
    Last Post: 04-23-2007, 08:45 PM
  4. Need help with Update Query
    By starswinger007 in forum Queries
    Replies: 1
    Last Post: 02-22-2006, 08:44 PM
  5. Update Query
    By canadian1121 in forum Queries
    Replies: 1
    Last Post: 11-15-2005, 04:04 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