View Single Post
  #2   Report Post  
Jamie Collins
 
Posts: n/a
Default

Bill Manville wrote in message

Pity my clients are all 2002 at latest


Why?

You can *create* the procedure within MS Access using the PROCEDURE
syntax e.g. I just tested your example

PROCEDURE MyProc [argSiteID] INTEGER;
SELECT * FROM Sites WHERE Sites=argSiteID

in Access95 and it works fine and will work for all subsequent
versions of MS Access.

You can *call* the procedure within MS Query using ODBC's call syntax.
Again, tested fine in Excel95 and above.

Jamie.

--