>I modified the code to put in the proper condition. Problem now is that when I
>attempt to requery the view after changing the value of the view parameter, I
>get the message 'View definition has changed.' Is there a way to get the view
>designer to use such a construct or to eliminate the requery problem? Thanks.

Would you care to post the whole SQL statement? It would make it easier for me to help....