Trying to get stored procedure to return a recordset?

How can I get a stored procedure to return a recordset. What I am trying to do is call a stored procedure from an MS Access97 program via a pass-through query which supplies parameters to the stored procedure. I want the stored procedure to get some records and then weed them out and do some manipulation and then send the results of that which will be several rows of data in a structure that I think of as a temporary non-persistent table back to the pass-through query so a report can then have its recordsource set to it? Can this sort of thing be done? How would it be done? I want the back-end to do all the manipulation because as I understand that will be alot faster. I do not want the resultset that is passed back to the calling program to be persistent.

Thank you very much!!!
Keith Received on Sat Jun 10 2000 - 00:00:00 CDT