Display multiple rows into one row query result

[kevinv]

I have a result for a query made from four different tables for which I would like to refine the result of this query grouping multiple rows into columns.

Attached is a pdf file showing the results being obtained by my query and underneath is how the result would like it be after running the query.

I am currently using Access 2010.

Any help please?

Thanks

Kevin

 

[CJ_London]

regret no pdf attachment - think you have to do a minimum of 10 posts before you can attach

 

[kevinv]

the original pdf files was over than 100kb limit size. A new upload has been added to my thread. thanks

 

[CJ_London]

still no pdf!

 

[kevinv]

it's named QRY.pdf. it's just under my name of my original post!

 

[CJ_London]

Sorry - found it now

What you need is a crosstab query which will be something like this - you might need to change names to suit your actual field names

TRANSFORM Sum(Table2.Percentage) AS SumOfPercentage
SELECT Table2.SLSalesManName, Table2.Description
FROM Table2
GROUP BY Table2.SLSalesManName, Table2.Description
PIVOT Table2.PriceLevels [COLOR=red]In ("WH","RET","CONS","WH/LESS")[/COLOR];

Note the bit in red - this is required so you can display in a form, insert into a table etc. The limit is 20 fields