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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.