on 02-24-2019 5:13 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.