What Does This Expression Do?

  • Thread starter Thread starter Guest
  • Start date Start date
Brevity is the soul of wit, but often does not help in problem solving. can
we see some more of the SQL please?
 
If that's been typed into the Criteria cell under a field in the graphical
query builder (and assuming you meant "BLANK-C" Or Is Null), then it's going
to return all rows where that field equals BLANK-C (or blank-c or Blank-C
or..., since Access isn't case sensitive), as well as all rows where no
value has been provided for that field.

In SQL, it equates to

WHERE Field1 = "BLANK-C" OR Field1 IS NULL
 
Sorry. I didn't write it. It turned out not to be the problem, it was just
some search criteria someone added, but thank you for your time.
 
Thank you. Yes, that is what it is.

Douglas J. Steele said:
If that's been typed into the Criteria cell under a field in the graphical
query builder (and assuming you meant "BLANK-C" Or Is Null), then it's going
to return all rows where that field equals BLANK-C (or blank-c or Blank-C
or..., since Access isn't case sensitive), as well as all rows where no
value has been provided for that field.

In SQL, it equates to

WHERE Field1 = "BLANK-C" OR Field1 IS NULL
Click to expand...
 
Back
Top