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

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

Post by Joe Alliso » Sat, 15 Nov 2003 00:04:24


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
 
 
 

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

Post by Rick Brand » Sat, 15 Nov 2003 00:24:17


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


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

 
 
 

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

Post by Jessic » Sat, 15 Nov 2003 00:33:59

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