does anyone know if its faster to append a query to a table, then query that table, or to just query the first query with another?? it seems like the append process is taking a while and i wondered if i should just save that for the final query..

If I'm understanding correctly, I would just query the first query with another, not put the records in a table. There might be rare circumstances where the calculations or whatever in the first made it more efficient to put those records in a table first, but generally query on query would be better.

thanks, that's what i was looking for