Query a numer field for 2 values

[RLJ]

I have a number field that I have set to the Field size of "Integer". I need a criteria to show a -1 and an Is Null. So I want both of these values to show in the query. I have tried in the Criteria box of the Query builder -1 And Is Null and it returns no records.



Thanks for your help.

[rzw0wr]

SELECT yourfields FROM YourTable WHERE YourFiled is null or Yourfield True;

Dale

[orange]

SELECT fld1, fld2, fldx
 FROM YourTable 
WHERE YourField is NULL or Yourfield = -1;

...untested...

Make sure you have data in the table to support your expectations( at least one NULL and one -1 value.

[RLJ]

I'm not sure either of these will work, since it is 1 field that I need to show values for both the -1 and Null Values. I have plenty of data in my table to support my expectations. I know how many records I should get returned.

[orange]

Did you try setting up your query based on post #3?

[RLJ]

Putting it like this:
Criteria: -1
or: Is Null

This returns no records. The combination of the 2 should return 16 null records and 62 -1 records for a total of 78 records

[orange]

Can you post a zip of your database--- just enough data to show the issue. Please remove anything private/confidential before posting.