Dynamic Creation of Pivot table in Access

[Dhiraj]

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.

 

[Dhiraj]

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