Access report / SQL Stored Procedure?

Can anyone show me how i can run an Access Report against a MSSQL server stored procedure?

I'm using access 2K and ms sql 2k, and the data tables in this access mdb is linked via odbc to sql server
Who is Participating?
Jokra_the_BarbarianConnect With a Mentor Commented:
Define a PassThru query where the sql calls the stored procedure. Set the report recordsource equal to the passThru query.
All Courses

From novice to tech pro — start learning today.