I have a SELECT query, let's call it query_A, that returns 15075 records
one of the fields, a text field, in query_A is called realm
I run a second query, using query_A as the dataset, with the condition: Where query_A.realm Is Not Null
this returns 14075 records
then I run a third query, using query_A as the dataset, with the condition: Where query_A.realm Is Null
this returns 498 records
but 14075 + 498 = 15073, which mean there are two records missing
this suggests that query_A has two records that are not Null, but that are also not not Null
I have checked the joins are the same, the join types are the same, I even deleted the third query and simply copy pasted the second query and altered the criterion from Is Null to Is Not Null. and none of this made any difference.
any ideas as to what I should be looking for to locate these two records?
many thanks,
Cottonshirt