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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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;
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.