AnsweredAssumed Answered

Questions on Retrieving records.

Question asked by LeoCA on Jan 9, 2009
Latest reply on Jan 12, 2009 by LeoCA


Questions on Retrieving records.


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.