Finding Non-Blank Records
So I have a bunch of records with a "notes" text field at the bottom... this field is left blank in many of the records (i.e. if there's nothing to make a note about).
I'm trying to create a report that pulls that field from all the records within a certain date range... however, when I do that, it pulls all the blank ones from that date range as well. Is there a script/shortcut/etc I can use so that Filemaker will only include the record in the report when the "notes" field is not blank?