Hi,
I am trying to find out how to integrate stored procedure with an Access report. For test purpose, I am trying the following procedure out of pubs database:
create procedure sp_gettitles
   @type char(12)
as
   select * from titles
   where type = @type

Now if I run the above stored procedure using the following paramters (in query analyzer)
exec 'busniess'
I will obtain a recordset in query analyzer. Now I need to find a way that I can use a form to allow the users to input the parameter and in turn the access report will be generated corresponding to this parameter. I appreciate any direction/help on this issue. Thanks.

Lookup "Passthrough Queries" in Access... they will do what you want.

--Jeff Moden