Hello,

How can one use Access to build reports but pass parms
into an MSSQL Server Stored Procedure to actually get the
result set for the Report?

Regards,

Paul

If using an .mdb, use passthrough queries.

Before opening the report (or during the Load event of the
report itself), you would modify the .SQL property of the
passthrough query's querydef object.

And ooh does this rock. Just lookup passthrough queries
to figure out how to set the connection and stuff.

David Atkins, MCP

....your the man...thanks David.

Paul
>-----Original Message-----
>If using an .mdb, use passthrough queries.
>
>Before opening the report (or during the Load event of
the
>report itself), you would modify the .SQL property of the
>passthrough query's querydef object.
>
>And ooh does this rock. Just lookup passthrough queries
>to figure out how to set the connection and stuff.
>
>David Atkins, MCP
>.
>