Convert query to table???

[kgcrowther]

I have a (crosstab) query that summarizes information in the way that I need for a module that I have written. However, I've noticed that the each time the module tries to pull a value from the query (every step of a Do loop) it takes seconds, compared to a "real-time" pull from a table. I have had a program running for about 2 days now, whereas a similar program that pulled data from only tables took only 15 minutes. I don't forsee needing the data in its original form.

How do I convert a query to a table? (Export the query to Excel and then import.)

I would appreciate any ideas. Thanks.

 

[Len Boorman]

Not sure that you can directly use a crosstab to a Make Table Query,

Query the Crosstab query with a Make Table Query

L