Home > IT Answers > Microsoft Windows > How to implement crosstab query in Access?
Shamu
75 pts.
 How to implement crosstab query in Access?
Access, CrossTab Query, SQL Server, SQL Server 2000
How to implement crosstab query

Software/Hardware used:
ASKED: September 22, 2010  4:24 AM
UPDATED: September 23, 2010  2:24 PM
RELATED QUESTIONS
Answer Wiki:
Hi Shamu. A Google search would return many results. Here's one: <a href="http://articles.techrepublic.com.com/5100-10878_11-6121381.html">How do I... create a crosstab query in Microsoft Access?</a>
Last Wiki Answer Submitted:  September 22, 2010  1:43 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

there is a crosstab query wizard in access, but it limits how many columns you can select.

Use this this wizard to create a simple crosstab, and the using designer edit the query to add extra columns as required.

Or you can code in SQL in access.
eg.

TRANSFORM First(dbo_vSid.[No Of Products]) AS [FirstOfNo Of Products]
SELECT dbo_vSid.Customer, First(dbo_vSid.[No Of Products]) AS [Total Of No Of Products]
FROM dbo_vSid
GROUP BY dbo_vSid.Customer
PIVOT dbo_vSid.YP;

The table this uses has 3 fields, YP, Customer, [No of Products]

Have fun

SidSeton
 95 pts.