Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006

    Unanswered: Update query question

    hi guys...

    got a question here. How can i do an update query to update the data from 5 fields in the same tables to 1 field.
    Example.... i have REASON1, REASON2,REASON3,REASON4,REASON5 and all of them contain data... what must i type at the update to section in the update query to tranfer all data to this field??

    thanks in advance....

  2. #2
    Join Date
    Jan 2004
    Norwich UK
    Just use [REASON1]&[REASON2]&[REASON3].....
    you'll end up with REASON1REASON2REASON3.
    If you require a space between them use [REASON1]&" "&[REASON2]&" "&[REASON3].....

  3. #3
    Join Date
    Apr 2006
    yeah... it works!
    thanks a lot....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts