Thanks to everyone that answered my last "What's faster?" question.

Here's another.

Selecting the records need into another table or using set filter to?

More info: The table I am selecting from has over 26000 records. The program currently searches the table for particular records 3 different times and stores the results into 3 different tables which are accessed numberously through out the program. Creating the tables takes forever! 2 of the created tables have under 1000 records, 1 has just over 1500.

A little background info: I'm a consultant at a state agency hired to patch the existing system written in 2.6 and grossly outdated.

Thanks again,
Sunshine