Reports from Pass-Through Queries with Parameters

  • Thread starter Thread starter Mix7
  • Start date Start date
M

Mix7

Hello,
In my access database (not an access data project!)
I'm trying to create a report based on a SQL Pass-Through
Query called spReportRequest. 'spReportRequest' is a
stored procedure with parameters: @ReportId and @loc.

I can only view this procedure in the DESIGN view of a
QUERY (it looks like this, spReportRequest 7, 'A23' (where
7 is the Report ID and 'A23' is the location).

My questions is , How do I create a report so that
differing reportId's and locations can be selected?


Any help would be greatly appreciated.

Mix7
 
You can use DAO to change the SQL of the saved p-t query.
CurrentDb.QueryDefs("spReportRequest").SQL = "spReportRequest " &
me.txtReportID & ", '" & Me.txtLoc & "'"
 
Back
Top