N
Novice2000
What does this expression do in the query? Thanks
BLANK-C" Or Is Null
BLANK-C" Or Is Null
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David F Cox
Brevity is the soul of wit, but often does not help in problem solving. can
we see some more of the SQL please?
we see some more of the SQL please?
D
Douglas J. Steele
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
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
N
Novice2000
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.
some search criteria someone added, but thank you for your time.
N
Novice2000
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