11 Replies Latest reply on Jan 12, 2009 7:15 AM by LeoCA

    Questions on Retrieving records.

    LeoCA

      Title

      Questions on Retrieving records.

      Post

      I have two questions:

       

      1. I have a layout that has all fields from a table. I want to retrieve all records that have (field1 IS NULL OR field2 IS NULL). How can I do this?

       

      2. We have records in a table with various status and would like to have user only retrieve ACTIVE (one of the status) record when specifying selection criteria (status is NOT one of the selection). Can this be done?

       

      Your help is appreciated.

       

      LeoCA