It only takes a second or two now. I can't imagine running it twice would make it noticably faster. :)

Thanks,

Michelle

>You should test for speed. Sometimes separating a SQL - SELECT command into several commands is much faster. For instance, I had a 9-table SELECT, which took me 50 seconds over the network. I separated in in several commands, joining first two tables, then a third, then a fourth, etc., and execution time dropped from 50 seconds to 2 seconds.