• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

parse multivalue field in ms access

In order to work with my data, I need to split the values in a multivalue field into separate fields.  Is this doable?
0
leahg57
Asked:
leahg57
  • 2
1 Solution
 
peter57rCommented:
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
 
als315Commented:
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
 
peter57rCommented:
I don't really see my post as a solution?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now