Hi. I'm setting up an program to automatically generate and email reports on a per-project basis to the respective project managers. I know how to make the emails happen, but I don't know how to programmatically separate my data on a per-project basis (currently the user has to select the projects one-by-one, click a command button to launch the report generation/email sequence. The sequence first generates a temporary, new table based on the project selected). My source table has a field called "projectnum", and has a varying number of records for each project. The number of projects also varies somewhat over time. Thanks for any help. I have extensive Access experience, but little VB experience.