how to in view designer

[johnbuckley]

How can I create the following view in the view designer?

Select * from table1 where;

field1=aa AND (field2=bb OR field3=cc OR filed4=dd)

Note position of brackets. I can't get it to group the OR s together.

Thanks

 

[danceman]

I suggest that you use the code it has made for it. Take that and modify it to create your view programmaticly.

OPEN DATABASE mydatabase
CREATE VIEW myview AS (this is the code from the view designer with the brackets you need) Attitude is Everything