simple query wont work

[NateProg]

declare @prm nvarchar
select @prm as NewField, phone
From tblAddress


This query validates/runs fine on my sql server, but when I try to run it from access, it doesn't prompt for the parameter. As well, when I look at it in access it shows this.

ALTER procedure test
as
declare @prm nvarchar
select @prm as Shift, phone
From tblsite

Why can't acces select a parameter?

 

[cmmrfrds]

You don't have a parameter in the SP.
ALTER procedure test
as
declare @prm nvarchar
select @prm as Shift, phone
From tblsite

Parameters are before the AS
Why are you using an nvarchar as a parm?

ALTER procedure test
@prm varchar(10) = ''
as
select Shift, phone
From tblsite where yourfield = @prm