how to combine two queries in access stored procedure

M

Michel Walsh

A Jet defined Stored Procedure is related to what you may also know as a
'parameter query' ( a query with a parameter ). You cannot get multiple SQL
statements in one Jet-defined stored proc. Use a VBA subroutine for doing
that, if you are using Access.


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access pass-through query to Oracle 10g stored procedure - results 1
stored procedure query 4
Are Jet 4.0 Stored queries faster than sql w/ criteria specified as the record source of a form? 7
Pass a parameter to a stored procedure from ms access 2
How to invoke a sql stored procedure from ACCESS 6
sql stored procedure 1
Access ADP Form and Stored Procedure as RecordSource 0
How To Call A SQL Stored Procedure From Access 1

Top