>Hi nadya,
>
>It does work with the view designer. However you'll have to omit the question mark. (so &cWhere) and be sure the cWhere variable does not exists. I'm not sure what you mean by "use this view as part of database" though. all views are part of a database....
>
>Walter,
I could not make it work. And I found that OR prevents using indexes. That's a little bit strange. Why AND allows to use indexes and OR doesn't?
If it's not broken, fix it until it is.
My Blog