Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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
0
arogyarajxavier
Asked:
arogyarajxavier
1 Solution
 
monosodiumgCommented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now