How do you prevent "Filter Excluding" from eliminating NULLs?

[ManningFan]

Go into a table where you have a field that has NULL values. Right-
Click on a record with a value in that field and choose "Filter
Excluding Selection". Some (or most, or all) of your records where
there is a NULL value in that field get eliminated.

Without getting crazy (i.e. designing your own bottons and "re-
inventing the wheel"), is there a way to make Access stop doing this?

[Allen Browne]

No. You must design your own query/filter/interface if you want different
behavior.

This is standard (and correct) behavior. More info in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.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.
"ManningFan" <ma********@gmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...

Go into a table where you have a field that has NULL values. Right-
Click on a record with a value in that field and choose "Filter
Excluding Selection". Some (or most, or all) of your records where
there is a NULL value in that field get eliminated.

Without getting crazy (i.e. designing your own bottons and "re-
inventing the wheel"), is there a way to make Access stop doing this?

[ManningFan]

On Aug 1, 10:46 am, "Allen Browne" <[e-mail]:

No. You must design your own query/filter/interface if you want different
behavior.

This is standard (and correct) behavior. More info in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

Thanks, Allen.