<div>
Yes, you need some function.<br />
split function can split separated string into substrings<br />
Dim A() as string<br />
A = split(&quot;12345,123,543,555&quot;,<wbr />&quot;,&quot;)<br />
A(0) will be equal to 12345 etc.
</div>


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.

<div>
I don't really see my post as a solution?
</div>


I don't really see my post as a solution?

<div>
<div class="content wysiwyg-content">
In order to work with my data, I need to split the values in a multivalue field into separate fields. &nbsp;Is this doable?
</div>
</div>


In order to work with my data, I need to split the values in a multivalue field into separate fields.  Is this doable?

parse multivalue field in ms access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.