Query not selecting blank fields.

[Guest]

Hi,

I wrote a query to select a record if either the name, phone number, gender
or date of birth are blank. To start with I made my criteria simple and used
only the date of birth field. So my criteria says WHERE
(((Memberdata.DateOfBirth)="Isblank"));

I know for a fact that there are blank date of birth fields because I can
see them upon opening up the table. Yet the query is not selecting them. I
even tried the "isblank" word and just trying to select for "" and " ".

I did import the file from a tab delimited text file. Maybe this has some
effect?

Any ideas as to why this is happening? I'm running Access 2000.

 

[Jason Lepack]

Try:

WHERE Memberdata.DateOfBirth is null

Cheers,
Jason Lepack

 

[Ray M]

try typing just: Is Null

Hi,

I wrote a query to select a record if either the name, phone number, gender
or date of birth are blank. To start with I made my criteria simple and used
only the date of birth field. So my criteria says WHERE
(((Memberdata.DateOfBirth)="Isblank"));

I know for a fact that there are blank date of birth fields because I can
see them upon opening up the table. Yet the query is not selecting them. I
even tried the "isblank" word and just trying to select for "" and " ".

I did import the file from a tab delimited text file. Maybe this has some
effect?

Any ideas as to why this is happening? I'm running Access 2000.

 

[Ray M]

try using just: Is Null

Hi,

I wrote a query to select a record if either the name, phone number, gender
or date of birth are blank. To start with I made my criteria simple and used
only the date of birth field. So my criteria says WHERE
(((Memberdata.DateOfBirth)="Isblank"));

I know for a fact that there are blank date of birth fields because I can
see them upon opening up the table. Yet the query is not selecting them. I
even tried the "isblank" word and just trying to select for "" and " ".

I did import the file from a tab delimited text file. Maybe this has some
effect?

Any ideas as to why this is happening? I'm running Access 2000.