generate a temporary table

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

Greetings,
I am using Access 2000. Can a query be created that generates a temporary
table, and then
a report uses that temp table for input ? How about a query working on the
generated temp table ?

thanks,
Darryl
 
Darryl said:
Greetings,
I am using Access 2000. Can a query be created that generates a temporary
table, and then
a report uses that temp table for input ? How about a query working on the
generated temp table ?
Click to expand...

Use a make-table query. Set the report's RecordSource property to the
newly made table's name.
 
A temp table will quickly bloat your database. You would be wise to look for
another strategy to do what you want to do. If you can create a make table
query to generate a temp table, why can't you use that query as a Select
query as the basis for your form or report?
 
Because the query has sub selects in it and Access Reports have limitations
when
using complex queries such as this. You start getting:

"Multi-Level Group by clause not allowed in a subquery".

Query works but if you put ANYTHING in headers/footers you get the error
above.

So, I was trying to come up with a simplified query mechanism to allow me to
have the
report I need.

-Darryl
 
Back
Top