access query removes rows where the field is empty
for the location column: if I specify
Not Like 'X'
it will remove any row where location is X.
But it will also remove rows where the location field is blank.
Since I didn't specify for it to remove the ones that are blank I would like to know how I can leave the rows where that field is blank
is null but that doesn't help. "Not Like X" still removes the blank ones