Jump to content

Trying to exclude blank rows from a query


Coastie

Recommended Posts

Hi,

I'm trying to run a query that will exclude all the rows that have nothing listed in a particular field. The default value for the field in question is None and it is a text field.

If I try IS NOT NULL I get all of the rows.

If I do IS NULL I get no rows

If I try = None I get no rows

So I'm at a loss as to what to do next.

Any help would be appreciated.

Edited by Coastie
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...