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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with expression builder in a Query to retrieve wanted dates 2
Returning null values 4
How to retrieve dates that meets a criteria using Query? Exp Build 1
#error - Blank 3
Help with expression builder in a select Query 2
Access Query problem 1
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Date Expressions/Criteria 1

Back
Top