I have created 2 identical select queries except that one should display records with a value greater than zero and the other should display records less than or equal to zero in the products.productfamily field.
The first query works fine and eliminates all records with a value less than or equal to zero as I have placed >0 in the query criteria field for the products.productfamily field
The trouble is that when I type <=0 in order to eliminate all records that are greater than zero, no record results display even though there are several records that fit the criteria.
This database field data type is numeric and contains a row source lookup value.
what can the issue be?
The first query works fine and eliminates all records with a value less than or equal to zero as I have placed >0 in the query criteria field for the products.productfamily field
The trouble is that when I type <=0 in order to eliminate all records that are greater than zero, no record results display even though there are several records that fit the criteria.
This database field data type is numeric and contains a row source lookup value.
what can the issue be?