Creating a parameter in a stored procedure in Access SQL adp

[Minimorgie]

Hi,
I am writing a stored procedure in Access which is connected to a SQL DB. I like to use the design window and have created parameters in the criteria column which require entry of a date range. However, I now need to create one which looksup the possible values from a column in the table that I am interrogating (in this case called tenure). How can I do this, I can't work out what to insert in the stored procedures paramaters tab. Alternatively I can insert the info in the SQL window but don't know the code.

Any help would be appreciated.

Thanks

 

[PWise]

why dont you creat this stored procedure

Create Procedure DistinctTenureDates

as

Select Distinct Tenure
From Tablename
order by 1

Return

 

[Minimorgie]

Thanks pwise, I can create a new stored procedure which successfully looks up the tenures in my table. However, I need to get the parameter to list the tenures so that when the user is running the report they can select from a list. How do I incorporate this stored procedure into the parameter?

Many thanks

 

[PWise]

What do you mean by the
stored procedures paramaters tab

How are yoy running the report

 

[TimKThailand]

Do you want create a query-by-form stored proc?

If so, check this [link

http://support.microsoft.com/kb/286828/EN-US/

]How to implement Query by Form (QBF) in an Access project[/url]

Hope this is what you're looking for.