Creating a Table from a Crosstab Query

[Pele]

I have created a Crosstab Query in Access and I wanted to
use that Query to create a Table in Access. I tried to
convert my Crosstab Query into a Make Table query but that
did not work. I realized though that I could send the
contents of the Crosstab Query into Excel and could re-
import it back into Access (not prefered option).

Please let me know what I can do to create a table from
the Crosstab query. Thanks.

Pele

 

[Allen Browne]

Create another query, and use the crosstab as an input "table".
You can turn this new query into a Make Table.

You will end up with something like this:
SELECT [MyCrosstabQuery].* INTO [MyNewTable] FROM [MyCrosstabQuery];

 

[Pele]

Thanks..It worked.

-----Original Message-----
Create another query, and use the crosstab as an input "table".
You can turn this new query into a Make Table.

You will end up with something like this:
SELECT [MyCrosstabQuery].* INTO [MyNewTable] FROM [MyCrosstabQuery];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have created a Crosstab Query in Access and I wanted to
use that Query to create a Table in Access. I tried to
convert my Crosstab Query into a Make Table query but that
did not work. I realized though that I could send the
contents of the Crosstab Query into Excel and could re-
import it back into Access (not prefered option).

Please let me know what I can do to create a table from
the Crosstab query. Thanks.

Pele

.

 

[dms]

I have created a Crosstab Query in Access and I wanted to
use that Query to create a Table in Access. I tried to
convert my Crosstab Query into a Make Table query but that
did not work.

Please let me know what I can do to create a table from
the Crosstab query. Thanks.