Returning wrong items

[cbende2]

Hello All,



I'm having a little trouble with some SQL,

WHERE (((DistTrackingTable.[Reviewed by ID]) Is Not Null) AND ((DistTrackingTable.[Check Requested by ID])=""));

My form is still returning Null [Reviewed by ID] records. I'm trying to have only records that are not null in the [Reviewed by ID] field AND records that are blank or null in the [Check Requested by ID] field.\

Any help will be greatly appreciated!

[ItsMe]

Null = Null

Empty String = ""

Null does not equal ""

[cbende2]

So what should I be using for linked number fields? If I set it to "Null" when I open my form, it returns all of my records.

[cbende2]

Got it, I used <>"" and "" for the criteria, and it's now giving me the correct items.

[ItsMe]

You could possibly have an empty string or a Null in a field of type Number. Depending on what you are after, you may want to validate for three values, Null, 0, and "". (For the purists, I realize Null is not a value)

[cbende2]

Ok, Ill set those criteria as well! Thanks!