Solved

parse multivalue field in ms access

Posted on 2013-07-01
3
546 Views
Last Modified: 2013-07-02
In order to work with my data, I need to split the values in a multivalue field into separate fields.  Is this doable?
0
Comment
Question by:leahg57
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 200 total points
ID: 39290816
Could be a problem because they are not really in the same field at all; they are in multiple records and only displayed in one field.

Why do you need to do this?  If you can explain the purpose then maybe we can suggest a solution.
0
 
LVL 39

Expert Comment

by:als315
ID: 39290817
Yes, you need some function.
split function can split separated string into substrings
Dim A() as string
A = split("12345,123,543,555",",")
A(0) will be equal to 12345 etc.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39292356
I don't really see my post as a solution?
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now