Create Table from Crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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
 
You must log in or register to reply here.

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

Query a crosstab query 2
Make-table query with around 2 ml records taking too long 0
append crosstabs 2
Q: Make Table from Crosstab? 7
Append crosstab result to a table 2
crosstab query child table count 5
Creating a table from series of Crosstab queries 3
update query 2

Back
Top