My crosstab query is running very slowly compared to the same query running using the Pivot Table wizard.

Is there any reason for this.

I have put indexes on the 2 fields required for the crosstab but to no avail.

We are talking about 50 times slower than the Pivot Table Wizard.

Many Thanks