Access Project/SQL Server-Display Data

Using Access 2000 Project and SQL Server 7. I want to display in the spreadsheet type format the results of a SQL statement I create. The SQL code works fine and the display works with Acces/ODBC to SQL, but in Project I can’t get the spreadsheet display unless from the database window I open a stored procedure I defined (that just takes the entire SQL statement as a parameter and executes it within the procedure). And then I’m prompted to enter the SQL code manually.

What is the VBA codeto either pass the parameter to the stored procedure and open it in the spreadsheet type format or, open a recordset in the same format? (I’ve already been able to create the recordset, but I have the same problem.)