Glad to see I passed the class walter.
FWIW, the SQL Select command based on a key value will perform as fast as a seek command.
Take a look at foxforum.com
Click on the last 3, 7 or 30 days option. It's actually calling this for each topic that comes up
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.