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
rrr333222Asked:
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.
0
All Courses

From novice to tech pro — start learning today.