AccessXP Query question

[bobh]

Hi All,
In AccessXP I have a query and on the query grid in the Outcome(text
field) field I put the
criteria of

<>"ToArb"

when a record is open this field is null and when the record is closed
the users has a
combo box of values to select, one being 'ToArb'

When I load the query none of the null values will display so I have to
use

<>"ToArb" Or Is Null

I don't ever remember having to include 'Is Null' before in order to
get all records not equal to
'ToArb'. Do I have a setting someplace? or option set? that is causing
this.
thanks
bobh.

[Allen Browne]

You're right, bobh.

A criterion of:
<"ToArb"
will return records only where the field has a value, i.e. it does not
return Nulls.

It's always been like that. See:
# The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

It's actually *very* important to understand how Nulls work, and why. There
are just a handful of issues where people constantly get tripped up. See:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"bobh" <vu******@isp.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...

Hi All,
In AccessXP I have a query and on the query grid in the Outcome(text
field) field I put the
criteria of

<>"ToArb"

when a record is open this field is null and when the record is closed
the users has a
combo box of values to select, one being 'ToArb'

When I load the query none of the null values will display so I have to
use

<>"ToArb" Or Is Null

I don't ever remember having to include 'Is Null' before in order to
get all records not equal to
'ToArb'. Do I have a setting someplace? or option set? that is causing
this.
thanks
bobh.

[bobh]

Hi Allen,
Thanks for your reply and links.......... Must have been a dream I
had cause I really do not remember ever having to include "Or Is Null"
in the query criteria to get nulls along with the rest of the data
before. But, today's a good day cause I learned something new :)
Happy Holidays to ya!
bobh.

On Dec 18, 11:09 pm, "Allen Browne" <[e-mail]>
wrote:

You're right,bobh.

A criterion of:
<"ToArb"
will return records only where the field has a value, i.e. it does not
return Nulls.

It's always been like that. See:
# The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

It's actually *very* important to understand how Nulls work, and why. There
are just a handful of issues where people constantly get tripped up. See:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"bobh" <[e-mail] in messagenews:11**********************@t46g2000cwa.g ooglegroups.com...

Hi All,
In AccessXP I have a query and on the query grid in the Outcome(text
field) field I put the
criteria of

<>"ToArb"

when a record is open this field is null and when the record is closed
the users has a
combo box of values to select, one being 'ToArb'

When I load the query none of the null values will display so I have to
use

<>"ToArb" Or Is Null

I don't ever remember having to include 'Is Null' before in order to
get all records not equal to
'ToArb'. Do I have a setting someplace? or option set? that is causing
this.
thanks
bobh.- Hide quoted text -- Show quoted text -