I need Query to fetch record in desired format

I am having a MS Access table as follows

model   size    qty
A       X       2
A       M       3
A       L       6
A       X       1
B       X       2
B       L       3
B       M       3

I need a query to get the data as follows

model   X   L   M
A       3   6   3
B       2   3   3

thank u
Who is Participating?
monosodiumgConnect With a Mentor Commented:
Use the Crosstab query wizard.
Select Model as a row heading, Size as column heading and Qty as value. It will generate the SQL for you.
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.