Filter Criteria of an empty cell, exclusion

Any trouble you encounter with the Pedias, here's the place to ask for help.

Filter Criteria of an empty cell, exclusion

Postby Dwwilkin » Wed Oct 26, 2016 10:55 am

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?
Dwwilkin
Junior Member
Junior Member
 
Posts: 2
Joined: Sat Feb 02, 2008 10:49 am

Re: Filter Criteria of an empty cell, exclusion

Postby Nora » Wed Oct 26, 2016 8:27 pm

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]").
User avatar
Nora
Site Admin
 
Posts: 2138
Joined: Sun Jul 04, 2004 5:03 am


Return to Support

cron