Results 1 to 2 of 2
  1. #1
    KPABA is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2013
    Posts
    1

    Convert rows into string

    Hello,

    I hope that someone can help me with this. I have an Access File with a table that looks like this:
    F1 F2 F3 F4
    206 997 Seattle WA
    206 998 Seattle WA
    206 999 Seattle WA
    206 201 Bainbridge Island WA
    206 212 Des Moines WA

    I need to have an output that I could copy and paste somewhere else. The output should be:

    (\+1206997)|(\+1206998)|(\+1206999)|(\+1206201)|(\ +1206212)

    Can someone help me with this?

    Thank you.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-09-2013, 11:00 PM
  2. Replies: 2
    Last Post: 05-17-2012, 03:52 PM
  3. Convert multiple rows to columns?
    By NelsonKauley in forum Programming
    Replies: 2
    Last Post: 04-04-2012, 04:59 PM
  4. Comparing 2 columns against 2 other columns
    By Amadeus in forum Access
    Replies: 4
    Last Post: 06-09-2011, 02:48 PM
  5. How to convert a db to txt
    By Joliet_Jake in forum Import/Export Data
    Replies: 5
    Last Post: 11-01-2010, 12:07 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