Thanks! This does exactly what I need. I was figuring I was getting to the point where I needed to start creating recordsets, and this just saved me a bunch of time. Thanks!...

I need to prepare weekly reports on how our sales people are doing, and currently have one query for each salesperson (~10). I have a button on a form that exports all of these queries to Excel, using commands like this:
DoCmd.OutputTo acOutputQuery, "QueryName" , acFormatXLS, QueryName-1.xls"

This works--but if I get a new salesperson, I need to create a new query and modify some code. If the criteria for...