Display multiple rows into seperate columns

[levinkev]

Hi,



I have a table containing the information as per attached sheet. Namely the table contains total workings for each product sales by salesman for each month and year for the last three years. i.e 2010, 2011,2012.

I need to create a query that displays result for each item and salesman having the year, month, qty & net values in one row.

Attached is an explanation of what I have in the table today and what would like to achieve with the query result in access.

Thanks for your help.

Kevinsample.zip

[June7]

Options:

1. Four crosstab queries (Year, Period, Quantity, Net), then join those queries
Be aware there is a limit of 255 fields for tables/queries

2. VBA code to rearrange the data to a temp table.