Wow, thanks a million.

I have to "duplicate" my queries dynamically for reporting. My customer has 30 incorporations and each of them has it's own set of tables in the same DB. He needs be to union all the data into a single recordset / reports for any number of cies chosen at run time by the user... now what's 30 times 250 lines for a query? :hehe:

...Thank God the migration into the ERP isn't complete yet!