How can I make a cross-tab query a make-table query

[Joe Allison]

When I make a crosstab query and then change the query
type to make-table and run, the resulting table does not
appear like the crosstab query. I need the table to look
exactly like the crosstab query. Any ideas??

Thanks

 

[Rick Brandt]

When I make a crosstab query and then change the query
type to make-table and run, the resulting table does not
appear like the crosstab query. I need the table to look
exactly like the crosstab query. Any ideas??

Use the Crosstab query as the input of a separate Make-Table query.

 

[Jessica]

I took a very basic approach for the same goal... i
created a new query using my crosstab query. double click
the "*" and made it a Make-Table Query. it's another
step, but it works fine when i run my macro.

hope that helps!
Jessica