Yes
It works, but I cannot modify it anymore using view designer.

I don't remember the trick with macro substitution, maybe that will do it.


>Have you tried coding the view manually instead of through the View designer?
>
>
>>Hi.
>>I want both :)
>>
>>One solution would be to use Expression 1 = 1 and ... the rest of where clause, but this lead to error when I try to modify the view.
>>I'll find something, thanks
>>
>>If I write "Expression"
>>>Trade offs may need to be made. Is it more important to use non-VFP keywords or to get the structure how you want it?
>>>
>>>