Query to convert Multivalue column into multiple lines of single-value column

In the attached example, could you please build me a query that takes the table tblData as the input (one of the columns of which is a multivalue column) and then outputs the same rows with the multivalues split into separate rows, one value per row. The expected output of the query, for this example is also included in the hardwired table qryExpectedOutput.

Thank you very much.
Multivalue.accdb
Member_2_7966563Asked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
We're not really here to "build a query for you". We'll be glad to help you build your query, of course, but we'd first need to see what steps you'd taken to create it yourself, and where you had troubles with it.

In case you haven't tried to do this yourself, all you really need to do is create a query with tblData as the source, and drag the ID, Team, and Nam.VAlue field to the query grid.

Here's a MSFT article about working with MVFs, which includes a section on creating queries.

https://support.office.com/en-us/article/using-multivalued-fields-in-queries-6f64f92d-659f-411c-9503-b6624e1e323a
0
 
Member_2_7966563Author Commented:
It was indeed that easy. For benefit of future users, here is the query I used:

SELECT tblData.Team, tblData.Nam.Value FROM tblData;
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.

All Courses

From novice to tech pro — start learning today.