Thanks, David!
What you've written is the conclusion I've come to, but I just wanted to be sure there wasn't some magic available out there! :-)
>Jerry,
>
>It's just a limitation of the view designer. You don't have any control over the () when combining AND and OR to get the precedence you want. Start with the view designer, then take it's code and fix it. I have a .prg with the views that can't be done in the VD for each app.
>
>>I had created a view using the view designer but couldn't persuade
>> it to form the syntax of the SQL statement the way I wanted it to be.
>> In order to solve this parsing problem in the view designer I had
>> to use CREATE VIEW command in the command window:
Nebraska Dept of Revenue