Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    CA, LA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge data from multiple fields (Access 2000)

    The database I am working on has 2550 records with 25 fields. Is there a easy way to merge the data from multiple fields into 1 field? Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge data from multiple fields (Access 2000)

    You could use an update query with something like this
    Field : Field1
    Table : Table1
    Update To : [Field1] & [Field2]
    Run the query, and delete field2 in the design view of the table.
    Make a backup of your database before trying this as this can't be undo.
    Francois

  3. #3
    New Lounger
    Join Date
    May 2002
    Location
    CA, LA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge data from multiple fields (Access 2000)

    Thank you. You are wonderful... Got no problem merging 5 fields of data into 1 field. Thanks again

Posting Permissions

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