Creating a Table from a Crosstab Query

  • Thread starter Thread starter Pele
  • Start date Start date
P

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
 
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];
 
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
Click to expand...


.
Click to expand...
 
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.
 
Back
Top