Searching for records that are not empty

[David Koontz]

Hello, I was wondering if it was possible to search for records based on a more general criteria than matching a value directly.  I need to find all records that are not blank for a particular field but wasn't sure how to express that.  I know that I can grab all the records and then filter in my client but that is time prohibitive for this particular layout.

[David Koontz]

Never mind, I found this: http://www.filemaker.com/help/html/find_sort.5.4.html#1027771

[Linda Julien]

On 9/14/13 4:59 PM, David Koontz wrote:
> Hello, I was wondering if it was possible to search for records based on
> a more general criteria than matching a value directly. I need to find
> all records that are not blank for a particular field but wasn't sure
> how to express that.

I do that by searching for ">0". This works for most field types.

For dates, you need to use an actual date, so I pick something much
earlier than I will ever find in my DB, like ">1/1/1800".

Hope this helps,
Linda