Pivot Tables with Access

Hi.

In my application, I use Vb.Net 2008 with MsAccess

In SQL SERVER, for creating Pivot Tables, I can use the commands: PIVOT and UNPIVOT in SqlServer, for creating them.

But, working with Vb and Access, how can I do it?

There is some way to create a Pivot Table, by code?

Thnak you

The only thing that springs to mind is creating a crosstab query, but its been a good 10 years since I have made one :).

Hi.

But the crosstab query, when acessing via VB, return to a normal query :(

Dammit..

I don't understand what you mean, what is 'return to a normal query'?

The pivot table only appears in Access.

Creating a dataset, in VB, the query is acessible only without pivot table.

The pivot table only appears in Access.

Creating a dataset, in VB, the query is acessible only without pivot table.