Filter Criteria of an empty cell, exclusion

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
Dwwilkin
Contributor
Contributor
Posts: 5
Joined: Sat Feb 02, 2008 10:49 am

Filter Criteria of an empty cell, exclusion

Post by Dwwilkin »

I want to set up A Smart Collection, but I want it to display only entries in the database (bookpedia) that have an item in a particular field.

I figured choosing the field, then an 'is not' and then I used two quotations ("" or " ") which is used in other database programs but here that didn't work. Anyone know how to do this for a search, parameter based on blank cells?
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Filter Criteria of an empty cell, exclusion

Post by Nora »

Leave out the quotes. Just an empty field will tell the smart collection that's what you're looking for. (For example, to get all entries without a genre value, set the smart collection to "Genre is [blank]").
Post Reply