Link to home
Start Free TrialLog in
Avatar of arogyarajxavier
arogyarajxavier

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of monosodiumg
monosodiumg

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial