View Full Version : On the Fly...Use a SQL Stored Prc as the Recordset for a report?


79ssecca
10-29-2003, 12:13 PM
Can I use a SQL Stored procedure as the recordset of a report in Access 2002. If so please share the code. I seem to be up the creek on this one.

pbaldy
10-29-2003, 02:55 PM
Was the answer posted on the other site not relevant?

Pat Hartman
10-29-2003, 03:08 PM
No coding is required. You would use a pass-through query to execute the stored procedure. Use the pass-through query as the recordsource of the report.