AnsweredAssumed Answered

Script Find with empty criteria

Question asked by synergy46 on Sep 4, 2012
Latest reply on Sep 5, 2012 by philmodjunk

Title

Script Find with empty criteria

Post

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:

Date::Dues=""

Date::Dues=*

... these don't work.  Can you nudge me in the right direction?

Outcomes