Results 1 to 3 of 3
  1. #1
    sajjad333 is offline Novice
    Windows XP Access 2002
    Join Date
    Aug 2012
    Posts
    2

    eed to split field into many fields in a single column

    Hi, Need to split field into many fields in a single column



    Example
    VERSION MS ACCESS 2002 SP3

    TABLENAME ALLTOGETHER
    ID MILTIGROUP
    30499 99474223@$99474223@$ABD4723@$
    35185 99465313@$3465135@$
    30433 99464286@$4246.86@$742.4686@$99464286@$99464286E@$

    RESULT REQUIRED

    TABLENAME SEPERATED
    ID MULTIGROUPSPLIT
    304999 99474223
    304999 99474223
    304999 ABD4723
    35185 99465313
    35185 3465135
    30433 99464286
    30433 4246.86
    30433 742.4686
    30433 99464286
    30433 99464286E

    Very basic knowledge in VB so kindly explain function plus calling from a query.

  2. #2
    sajjad333 is offline Novice
    Windows XP Access 2002
    Join Date
    Aug 2012
    Posts
    2
    oops! Need to split field into many fields in a single column

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Complicated because the string is not consistent in the number of parts.

    Will need custom function in VBA code to parse and save records to table. Will involve recordset and loop structure. Review http://www.utteraccess.com/forum/Spl...-t1775222.html
    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: 2
    Last Post: 07-27-2012, 08:27 AM
  2. Replies: 3
    Last Post: 02-24-2012, 06:20 PM
  3. Replies: 6
    Last Post: 01-13-2012, 09:17 AM
  4. Split Database only allowing single user access
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 11-08-2011, 11:12 PM
  5. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 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