Quierying for blank entries

[George]

Good Afternoon all.



I would be grateful if someone can advise me on a query problem: I want to make a query based on a text field which contains some blank entries. I am unsuccessful querying for results with blank values. My 3 attempt at queries were: 1. "" ,2. ="", and 3. Not "cancel", Not "undersubscribe"

in case 1 and 2 nothing was returned.

Is this a difficult problem to solve.

Thanks

George

[JoeM]

="" or Is Null

Should return all blank or null entries.
If it does now, then I expect that some of those entries really aren't blank, but have some spaces or other special characters in them.
That can easily be proven using the LEN function to find the length of each field. If it is one or greater, there is something in there (whether you can see it or not!).

[George]

="" did not work
Is Null worked

Thank you JoeM

[JoeM]

No, I meant to include both of them in a single criteria statement, just like I have it written (not one or the other!).
Blank and Null do not mean the same thing in all database programs. Writing the criteria like I have showed you will cover all the bases!

[George]

Will do. I understand.

Thanks.