SP

[amal1973]

Hello ...
I have created a Stored Procedure in SQL server With one perameter .
I want to be able top connect to access 2000 and pass this perameter. what are the steps that i should take...
thanks in advance

Create PROC InsertAccountNumber @Account nvarchar(255)
AS
SELECT Com_Names.COMPANY_NAME,
Expense_Analysis.ACCOUNT,
SUM(Expense_Analysis.AMOUNT) AS Amount

FROM Com_Names INNER JOIN
Expense_Analysis ON
Com_Names.ACCOUNT = Expense_Analysis.ACCOUNT
WHERE Expense_Analysis.ACCOUNT =@Account
GROUP BY Com_Names.COMPANY_NAME,
Expense_Analysis.ACCOUNT

EXEC InsertAccountNumber @Account='0862001'

What shell i do in access and what shell i create to just enter the account number to have the result..
thanks to all

 

[tlbroadbent]

Check this article.

ACC: How to Simulate Parameters in an SQL Pass-Through Query

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.