Hi

Is it possible to make table from a crosstab query?

Thanks

Regards

I would reccomend select * in this situation

I believe that SQL 2005 also has the pivotKeyword that is available..
so if you wanted to do this natively in SQL Server you could get a LOT
better performance

-Aaron

Jerry Whittle wrote:
> Sure. The SQL would look something like:
>
> SELECT DivisionNum,
> Months,
> Count(Employee) AS CountOfEmployee,
> Count(Employee) AS [Total Of Employee]
> INTO tblCrosstab
> FROM qryCrosstab
> GROUP BY DivisionNum, Months;
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "John" wrote:
>
> > Hi
> >
> > Is it possible to make table from a crosstab query?
> >
> > Thanks
> >
> > Regards
> >
> >
> >