Search for Low Values

[kanjeep]

How do I get my query to only pull out the records that have low values(*LV)/no value in a field?

 

[Cosmos75]

What would be considered a low value?

The following SQL shows data from tblData where lngValue = Null or lngValue < 5.

SELECT tblData.*
FROM tblData
WHERE (tblData.lngValue Is Null) OR (tblData.lngValue<5);

 

[ByteMyzer]

kanjeep,

Your question is ambiguous at best, and gives no clear specification of your requirement. Suppose you post an example of the data you are attempting to query, along with an example of the expected query results.