>Mark,
>
>If you go to the Filter Tab and click the combobox in field, select expression you can put your expression in there. The Update Criteria page controls making the view updateable.
>
>>Thank you! That makes things a bit clearer. I tried crating a view yesterday as per your suggestion. I had difficulty duplicating the WHERE clause that I had created just by typing in a straight SQL statement from the command window. The where went "where !empty(somedatefield)". This isn't a choice in the View designer and the SQL cannot be changed, only viewed, right? So how would you perform such an action? I tried using the NOT IS NULL, but didn't have any luck.


David,

Thank you so much for the lesson! Had no idea you could drag & drop a view onto a table -- that worked great and I've achieved my desired results. Thanks again!

Sincerely,

Mark