The easiest way is to develop the SQL and test it in a PRG. Then use Create View to update the DBC. Erik Moore's eView program (in the Files section here) will help you update the other view properties.
HTH
Barbara
>Hi,
>
>Made a little progress of RV filtering but now a big problem has occurred. I cannot modify my view for the table I was working on. I entered a function under heading of example and it accepted it. I clicked on the table and it run the first time but no records. And now it won't let me modify the filter. How do I corecct this filter entry?
>
>Thanks in advance!
>Roland