generate a temporary table

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
 
M

MGFoster

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.
 
P

PC Datasheet

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?
 
D

Darryl

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
 
Top