MySQL procedure

[aztec]

Hello
I have been advised to move this post here by artacus, a forum helper.

I need the equivalent of a stored proceedure in Access 97 and I do not use that programme but from research I do not think Access uses stored procedures at all, it creating a problem for me.

In MySql I would write it as follows:

[code]
CREATE PROCEDURE dbo.ParagonArchiveRefs
(
@matdesc nvarchar(20)
)
AS
select mastdesc, matno, storedate, storageref
from paragon...matter
where matdesc like @matdesc  [/code]



Any help or direction appeciated

Kind Regards

[MCP]

It works differently in Access. Where will the parameter be coming from?

[aztec]

Thanks mpc sorry to be late replying but I have just got online again

Basically I want to be able to activate a search box which will allow users to enter a reference.

The reference will be within the matdesc field. I then want it to go and find all records where the reference is within matdesc and return the rows (ie, showing matno, storedate and
storageref)

I hope this makes sense to you but because I do not use access it is cetainly a problem for me any help would be appreciated.

Kind regards