Access Stored Querys, ASP and variable number of parameters

[Maldini]

Hi,

I remember having done something similar with MS SQL Server where if no parameter was provided, SQL Server's stored procedure could substitute some "match all" wildcard type of value in.

Is this possible using the Access version of stored queries? basically, I have a number of drop down boxes I'm hoping to use to filter data. I've googled about, but couldn't seem to find anything.
Or would I have to drop the stored query and revert to SQL string building within ASP?

Any tutorial links or tips on how to achieve this effect wouldbe appreciated.

Thanks.

Maldini

 

[Maldini]

Think I've found a solution.

 

[a6m1n0]

And that would be?

-a6m1n0

"Don't try to reinvent the wheel." -My HS FORTRAN Professor