Crosstab query

J

jeanulrich00

Hi

Is it possible to create a table from a crosstab query ?

The crosstab query was made with SQL code and cannot be represented in
design view (only SQL view)

If the answer is yes, what approach should I use or what is the code
to do what I want

Thanks a lot to help me
 
J

John W. Vinson

Hi

Is it possible to create a table from a crosstab query ?

The crosstab query was made with SQL code and cannot be represented in
design view (only SQL view)

If the answer is yes, what approach should I use or what is the code
to do what I want

Thanks a lot to help me
Click to expand...

Create a new MakeTable query, and base it on the stored Crosstab query
(instead of basing it on some table).

John W. Vinson [MVP]
 

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

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
cannot use the crosstab of a non-fixed column as a subquery 3
Create table from a crosstab query 2
problem with crosstab query 1
Form based on crosstab query 1
Crosstab Query - Additional Data 1
Crosstab query - MS Access 2000 2
Crosstab Date Range in Reports 3

Top