SQL StoredProc Params in Access Report!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey there,

I have an ADP with a report based on an SQL stored procedure in an sql
database. The report accepts a @StartDate and an @EndDate as params. How do
I display the values of those entered by the user in the report? Used to be
able to concatenate Query parameter values in access like so:

="For dates " & [StartDate] & " to " & [EndDate]

How do I do this in a report based on an SQL StoredProc with params?

Thanks!
 
Kelly:

The following KB article may be a useful reference:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208630

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hey there,

I have an ADP with a report based on an SQL stored procedure in an sql
database. The report accepts a @StartDate and an @EndDate as params. How
do
I display the values of those entered by the user in the report? Used to be
able to concatenate Query parameter values in access like so:

="For dates " & [StartDate] & " to " & [EndDate]

How do I do this in a report based on an SQL StoredProc with params?

Thanks!
 
Back
Top