We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

I need Query to fetch record in desired format

arogyarajxavier
on
Medium Priority
319 Views
Last Modified: 2008-02-01
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
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.