SQL question re WHERE usage anf Date/Time

[McKirahan]

Using MS-Access with "myDate" defined as a Date/Time field, how do I use SQL
to select only those records (rows) that have have nothing in this field?

The following does not work:

SELECT myFields FROM myTable WHERE myDate = ''


This gives me the opposite of what I want

SELECT myFields FROM myTable WHERE myDate <> Null;

but this returns nothing:

SELECT myFields FROM myTable WHERE myDate = Null;


Thanks in advance.

[Bob Barrows [MVP]]

McKirahan wrote:

> Using MS-Access with "myDate" defined as a Date/Time field, how do I
> use SQL to select only those records (rows) that have have nothing in
> this field?
>
> The following does not work:
>
> SELECT myFields FROM myTable WHERE myDate = ''
>
>
> This gives me the opposite of what I want
>
> SELECT myFields FROM myTable WHERE myDate <> Null;
>
> but this returns nothing:
>
> SELECT myFields FROM myTable WHERE myDate = Null;
>
>

Almost.
SELECT myFields FROM myTable WHERE myDate IS Null;

Bob Barrows


Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[McKirahan]

"McKirahan" <News@McKirahan.com> wrote in message
news:LM%zc.115160$Ly.27189@attbi_s01...

> Using MS-Access with "myDate" defined as a Date/Time field, how do I use

SQL

> to select only those records (rows) that have have nothing in this field?
>
> The following does not work:
>
> SELECT myFields FROM myTable WHERE myDate = ''
>
>
> This gives me the opposite of what I want
>
> SELECT myFields FROM myTable WHERE myDate <> Null;
>
> but this returns nothing:
>
> SELECT myFields FROM myTable WHERE myDate = Null;
>
>
> Thanks in advance.

The following worked:

SELECT myFields FROM myTable WHERE Not IsDate(DateChanged)

Is there something better (or different)?

[McKirahan]

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uei7es8UEHA.3512@TK2MSFTNGP12.phx.gbl...

> McKirahan wrote:

> > Using MS-Access with "myDate" defined as a Date/Time field, how do I
> > use SQL to select only those records (rows) that have have nothing in
> > this field?
> >
> > The following does not work:
> >
> > SELECT myFields FROM myTable WHERE myDate = ''
> >
> >
> > This gives me the opposite of what I want
> >
> > SELECT myFields FROM myTable WHERE myDate <> Null;
> >
> > but this returns nothing:
> >
> > SELECT myFields FROM myTable WHERE myDate = Null;
> >
> >

> Almost.
> SELECT myFields FROM myTable WHERE myDate IS Null;
>
> Bob Barrows
>
>
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>

Thanks!