Crosstab to table

  • Thread starter Thread starter John
  • Start date Start date
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 said:
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 said:
Hi

Is it possible to make table from a crosstab query?

Thanks

Regards
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create table from a crosstab query 2
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
problem with crosstab query 1
dynamic columns number in crosstab report 4
Form based on crosstab query 1
Crosstab query 1
Access Crosstab to Table 2
CrossTab Manipulation 4

Back
Top