Did you set it as the data source like in the sql string -

SELECT * FROM Query1

Do you have the report option to show stored procedures? CR looks at Access as stored procedures. What connection technology are you using (ODBC, ADO, DNS)?