Thanks for the reply based on such a vague question:

I'm calling the report from Access. The report will be run each day, filtered by say 12 employees. Therefore it will be run 12 to 13 times per day, then weekly, then monthly.

I'm not awfully concerned about absolute speed (a couple seconds here and there), but rather serious operating problems/crashes down the road when the database is pouplated with thousands of records.

Thanks again for trying to give a reasonable answer to such an open ended question.

Ernest