I have the following procedure that works great when I run it from SQL
Server Manager.
EXEC prGetReferrerPayroll @startdate, @enddate, @totalsignups,
@totalopts.
All I do is replace the variables with actual dates...
EXEC prGetReferrerPayroll '02/01/2007 12:00 AM', '02/14/2007 11:59
PM', '01/01/2007 12:00 AM', '01/01/2007 12:00 AM'
In Access, I have created a link to the SQL db and can run a number of
queries, etc. However, I just cannot figure out how to run this
procedure.
I've tried making it:
PROCEDURE prGetReferrerPayroll '02/01/2007 12:00 AM', '02/14/2007
11:59 PM', '01/01/2007 12:00 AM', '01/01/2007 12:00 AM'
But then tells me "Syntax Error in Parameter Clause."
Any help is greatly appreciated!