Query not selecting blank fields.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...
 
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.
Click to expand...
 
Back
Top