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

  • Thread starter Thread starter Joe Allison
  • Start date Start date
J

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
 
Joe Allison said:
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??
Click to expand...

Use the Crosstab query as the input of a separate Make-Table query.
 
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
 
Back
Top