Skip to Content
0
Former Member
Oct 17, 2007 at 09:55 AM

How to Convert Rows to Column in Query

66 Views

Dear All,

I'm having problems in converting the data from rows into columns. Eg:

- item A sold on 01/01/07 = 5 kg

- item A sold on 10/01/07 = 5 kg

total item A sold in "JAN" = 10kg

- item A sold on 01/03/07 = 20 kg

total item A sold in "Mar" = 20kg

I did a query and it appear as below (in which I need the period as column)

Item Qty Period

-


-


-


A 10 2007-01

A 20 2007-03

The output I need is :

Item Jan Feb Mar

-


-


-


-


A 10 - 20

I've refer to the query posted in "Item History Query", even though I can get the column from Jan - Dec, but the total quantity for each month is not accurate. Please advise, and thanks for your time.

Cheers,

Serene