Pivot Table View not working

[olmie75]

I have a query that I want to open in Pivot Table mode, so I use the code:
DoCmd.OpenView "dbo.qryHoursPivot", acViewPivotTable, acEdit
The pivot tables open, but when I try to set the rows/columns/detail, the message: "The query could not be processed: The data provider didn't supply any further error information". The query opens fine in datasheet mode, so I don't understand what the problem could be. Any ideas?

 

[Painy]

I think you'll find that a pivot table is only valid for Access queries, it's not a functionality available within SQL Server.
You could probably create a query over the SQL database from an MDB front-end but not from an ADP as the 'query' is actually a view.
Hope this helps