cancel
Showing results for 
Search instead for 
Did you mean: 

Filter on Null/Empty/Blank field

0 Kudos

I am trying to use an older Access DB. It doesn't work with current Access, so I can't see what is really there. I am trying to filter on one of two fields. One is text. One is a date. In the report, these fields appear to be blank. I want to select records like this and exclude records with something in these fields. Nothing I've tried works. There are no choices for or I don't know how to select is blank, is null, is empty. None of the choices work. I've tried is equal to, is less than. Nothing works. I am on trial of this product. If I can't get past this, I have no use for it.

It appears that every filter ignores the records I want, the ones with apparent nothing in the fields.

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

Create a formula for each field you need to check. The formula will look something like this:

{@CheckTextField}

IsNull({MyTable.MyField}) or Trim({MyTable.MyField}) = ""

For any non-text fields, you'll just use the IsNull piece of this.

You would then go to the Select Expert and edit the formula instead of adding fields to it. You'll then add something like this to the formula:

{@CheckTextField} or {@CheckDateField}

-Dell

Answers (0)