Erik,

Thank you for eview and for your explanation of my demanding parameterized view. I've used your utility several times to untangle a view, and I've learned more about views from using it.

I eventually put all the views and SQL statements into a prg, so now I'm rid of the MS finnicky view editor and can use my IIF() statements without objection.

I appreciate your answer because sometimes I get determined/stuck, and whoosh, two days go by. I'm stuck no more, and have eview --- Thank you.

Sylvia