Pivot Tables with Access

[helderjsd]

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

[Grimfort]

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

[helderjsd]

Hi.

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

Dammit..

[Grimfort]

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

[helderjsd]

The pivot table only appears in Access.

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

[helderjsd]

The pivot table only appears in Access.

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