Results 1 to 3 of 3
  1. 04-30-2011, 08:34 AM #1
    younggunnaz69
    younggunnaz69 is offline Novice
    Windows Vista Access 2003
    Join Date
    Apr 2011
    Posts
    7

    create comma delimited string from column in query

    I would like help creating a macro to create a comma delimited string from a column in a query. The string can be in a word doc or .txt file i just have to be able to copy the string and paste it in another application. I am pretty new at access and hope I'm describing it correctly. thanks for any help provided

    Example:

    ZIP



    14580
    15487
    12576
    15358
    15474

    result- 14580, 15467, 12576, 15358, 15474
    Reply With Quote Reply With Quote
  2. 04-30-2011, 10:45 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    This type of thing?

    Return a concatenated list of sub-record values
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 04-30-2011, 04:26 PM #3
    ajetrumpet
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by younggunnaz69 View Post
    The string can be in a word doc or .txt file i just have to be able to copy the string and paste it in another application.
    it should also be noted that "another application" will not be possible unless there is a vba library for it. what program?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Convert Comma Separated List String to Records
    By dgj32784 in forum Access
    Replies: 2
    Last Post: 04-07-2011, 10:15 AM
  2. How get all values in comma delimited format when grouping (for use in ArcGIS)
    By AJOSEPH in forum Queries
    Replies: 3
    Last Post: 03-20-2011, 04:45 PM
  3. Importing non-fixed width, non-comma delimited text file into Access 2003
    By asawadude in forum Import/Export Data
    Replies: 5
    Last Post: 02-20-2011, 08:22 PM
  4. Parsing A Comma Delimited Field
    By AccessGeek in forum Import/Export Data
    Replies: 6
    Last Post: 02-03-2011, 01:52 PM
  5. getting a comma separated string from a recordset in MS Access
    By sanand in forum Access
    Replies: 1
    Last Post: 07-31-2009, 03:57 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums