Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006

    How to extract names from 1 large field

    I'm not a programming guru, so use nice small words! <G>

    I've got a database where one of the fields is called 'participants'. In that field could be between 1 and 30 names, separated by commas.

    What I'm trying to do is write a query/macro/code (whatever works) that will grab the individual names so I can spit them out to a mailmerge to print certificates. I've played with the instring, trim, left & right commands and can't find a combination that will do what I want.

    If anyone knows a better forum than 'general' for this question, by all means let me know and I'll post it there.

    Thanks in advance...Tepin

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    In the first place, why do you have just one field that contains what amounts to multiple records? Sounds like poor database design.

    If there is nothing you can do about that, you would probably have to write some VBA code to parse through the string one byte at a time looking for the comma.

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

Similar Threads

  1. Median and Mode for a large table
    By brandon in forum Access
    Replies: 0
    Last Post: 05-08-2008, 09:26 AM
  2. Replies: 0
    Last Post: 12-31-2007, 11:12 AM
  3. Extract numbers from text string strored in a field.
    By khabdullah in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 06:55 PM
  4. Import large txt into access
    By klm127 in forum Import/Export Data
    Replies: 0
    Last Post: 04-23-2007, 06:22 AM
  5. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 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