Making a Table from Crosstab Query

[smiley1978]

I have the results of a Crosstab query that I want to put into a tab, but I cannot use Make table with Crosstab. Is there a way to save results of Crosstab into a table?

 

[Joe4]

If its just a one-time thing, one easy way would be to export/copy your Cross-Tab query into Excel. Then import the Excel file into Access.

Out of curiosity, why do you want to write the result of your query back to a table?

 

[SydneyGeek]

You can use a make-table with a crosstab, just not directly in the crosstab query.
Create the crosstab, then create a second query based on the crosstab, and turn that into a make-table. Same goes for Union and pass-through queries.

Denis

 

[smiley1978]

Thank you. I am putting the results into a table because I am using the results in multiple queries and tables and would prefer to only run the query once.