Create Table from Crosstab

J

J

I know you normally need 2 queries to do this, but does anyone have any
suggestions on how to do this in code. Perhaps create a table on the fly and
append data to it??
 
D

Dale Fye

Why don't you want to run a MakeTable query?

1. Create the CrossTab query
2. Create a second query that uses the Crosstab as its data source, and save
it as a MakeTable Query
3. In your code, use the execute method to create the table
currentdb.Execute "Query2"

HTH
Dale
 
Top