query - remove ********

  • Thread starter Thread starter christine t.
  • Start date Start date
C

christine t.

I imported a data set with one field that contains ******** which is the
default for no data in that field. In my query I'd like to only return rows
that contain a value in that field. I've tried "not ********" which did not
work. What is the correct expression for this? Thanks.
 
I imported a data set with one field that contains ******** which is the
default for no data in that field. In my query I'd like to only return rows
that contain a value in that field. I've tried "not ********" which did not
work. What is the correct expression for this? Thanks.
Click to expand...

<> "********"

That's the "not equal" operator.
 
Back
Top