Filter Excluding Selection

[MikeCDPQ]

I have a control with both values and blanks

Using the Filter Excluding Selection also filters out my records where the value is blank.

I want the filter to return all blanks and whatever is not equal to selected value.

Thanks for you suggestions !

Michel

 

[Remou]

You probably need:

<...> Or Is Null

 

[WildHare]

While Rem is technically correct, and it sounds like you have NULL , not "blanks", per se, it's worth noting that in some situations, we need to determine whether the data in question is actually composed of numerous "blanks", e.g. the character produced by hitting the space bar ( CHR$32 ) or NULL, which is the absence of any data. Two very important things to remember about most database system are:

Blanks <> NULL
Zero <> NULL

and, I suppose, thirdly,

NULL <> ANYTHING

If your data actually does contain a bunch of BLANK characters, which I've seen before, then your filtering needs to get a little trickier.

Where FieldName = "somevalue" OR FieldName Like " " <-- {Insert a number of blanks between the quote marks that would most likely match the number of blanks actually in your data.

For example, I once had to work on a DB where someone else had cunningly replaced all the NULL 2-character state values with two blanks instead...was a head scratcher as I tried to zero in on what I thought were NULL values until I figured it out...of course, on display on a form or on a report, NULL looks suprising like BLANKS..


--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman

 

[Remou]

Or
[tt]Trim(FieldName & " ")=""[/tt]

 

[MikeCDPQ]

Thanks everyone.

I got it to work.