Hi bash

Thanks for your suggestion. It may work. I know the query in advance, and the value of the parameter is determined at run time.

The only reservation I have is that I am running on a multi-user system and if I use a fixed name for the temp table then I risk overwriting it. If I use a unique table name then I have the problem of telling my report which table to use.

Why is life never simple?