I need a way to delete output records from a query based on duplicate fields. Is there a string that I can use in the criteria that will filter out duplicates. To complicate matters, some of the values in the field are null and those must remain in the output.
I have tried First as a total, setting the property for the Query as UniqueValue and I have also tried UniqueRecord.
