Script Find with empty criteria
I have a Members db with a Members table that is related 1 to many to Dues. Dues is in a portal on the Members layout.
The relevant 2 fields are : Members:: MEMCan (holds either "Member" or "Candidate"
and Dues::Date (Holds the date of the dues payment)
I want to script a Find that will include MemCan="Member" and Omit Dues::Date= [blank or isempty(Dues::Date]
I seem to remember some counterintuitive trick that expresses an empty criteria. I have tried:
... these don't work. Can you nudge me in the right direction?