Hi
I am trying to exclude value 40 in a query. Most records in this field are blank, some have numerical values. I would only like to exclude 40 from those values keeping all the blanks and other values.
When I do:
<>40
It also removes all the records with where this field is blank keeping only the records with a numerical value (excluding 40).
Please advise.
Thank you
I am trying to exclude value 40 in a query. Most records in this field are blank, some have numerical values. I would only like to exclude 40 from those values keeping all the blanks and other values.
When I do:
<>40
It also removes all the records with where this field is blank keeping only the records with a numerical value (excluding 40).
Please advise.
Thank you