how to pass parameters to query that is build in access

[smriti]

Dear all,

 

I am using MS Access Database.

I am building the queries in Access Database and Executing them using stmt "Execute QueryName".

Is there Any way to pass the parameters to Access Queries.

That is i want to Execute the query by passing a value to it.

Is it possible to do so?

If so please mention it.

 

Thanks.

[stustarz]

You would just list the parameters in the order the query is expecting them after the queryname (comma delimited) :

 

Execute QueryName Parameter1, Parameter2 etc...