• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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