PIVOT TABLE VIEW

[sharma.durga]

Hello-

I am running a query and when it gives me results, i go to view then
pivot table view. Is there anyway i can create a command where with a
click of the bottom, it will show me the pivot table. Or retrieve the
data in pivot table view?
Thank you
Durg

 

[aaron.kempf]

what you are looking for is something called a Docmd.RunCommand
'constant'

I can't find the correct one... but all you need to do is google it and
look

Docmd.RunCommand acCmdPivotView or something along those lines

-Aaron