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.

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" <vulcaned@isp.comwrote in message
news:1166460390.079912.113650@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.

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" <AllenBro...@SeeSig.invalid>
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" <vulca...@isp.comwrote in messagenews:1166460390.079912.113650@t46g2000cwa.g ooglegroups.com...
>
>
>

>

>

>

>

>