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.

You must either use DAO or else dump the ADO recordset to a temporary table, and then bind the report to that temporary table. The read/write behavior of the Recordset property is determined by the ...

To see records in a specific order, sort them. To sort data in a Recordset object that is not a table, use an SQL ORDER BY clause in the query that constructs the Recordset. You can specify an SQL ...