Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...