Re: Pivot Tables with Access
The only thing that springs to mind is creating a crosstab query, but its been a good 10 years since I have made one :).
Re: Pivot Tables with Access
Hi.
But the crosstab query, when acessing via VB, return to a normal query :(
Dammit..
Re: Pivot Tables with Access
I don't understand what you mean, what is 'return to a normal query'?
Re: Pivot Tables with Access
The pivot table only appears in Access.
Creating a dataset, in VB, the query is acessible only without pivot table.
Re: Pivot Tables with Access
The pivot table only appears in Access.
Creating a dataset, in VB, the query is acessible only without pivot table.