K
KReese
I have a table that includes names and addresses. I know some of the “Stateâ€
data is missing, therefore I tried running a query to give me all records
where the ‘State’ field is null. The query does not return any data. I ran
a query to give me all records where the ‘State’ field is ‘not null’; the
result set included ‘State’ fields with actual states and those that are null.
If you look at the table, you can see there is no data in the ‘State’ field
for some of the records. I checked to see if maybe there were spaces in the
‘State’ field throwing off the query, but there are no spaces in the State
field. I have used queries like this hundreds of times before without a
problem. I have to be overlooking something. Any ideas? Thanks in advance.
data is missing, therefore I tried running a query to give me all records
where the ‘State’ field is null. The query does not return any data. I ran
a query to give me all records where the ‘State’ field is ‘not null’; the
result set included ‘State’ fields with actual states and those that are null.
If you look at the table, you can see there is no data in the ‘State’ field
for some of the records. I checked to see if maybe there were spaces in the
‘State’ field throwing off the query, but there are no spaces in the State
field. I have used queries like this hundreds of times before without a
problem. I have to be overlooking something. Any ideas? Thanks in advance.