By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

AccessXP Query question

P: n/a
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.

Dec 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Dec 19 '06 #2

P: n/a
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: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 -
Dec 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.