Dynamic Creation of Pivot table in Access

[Guest]

Presently, I am creating pivot table manually where I have defined the
grouping, but then I am having problem as the grouping range keeps on
changing.

I wish to create a dymanic pivot table which I wish to attach with a query.

 

[David S via AccessMonster.com]

Have you tried using the Query Design wizard to create a Crosstab query? This
is what Access uses for pivot table type output

 

[Guest]

I did not use any wizard and wrote the query in SQL.

 

[David S via AccessMonster.com]

I did not use any wizard and wrote the query in SQL.

The wizard's quite nice and helps you with the format of the query, and
you'll end up with SQL that looks something like this:

TRANSFORM Sum([Sales])
SELECT [CustomerID], Sum([Sales]) AS [Total Of Sales]
FROM [tblSales]
GROUP BY [CustomerID]
PIVOT [Week];