query - remove ********

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.
 
J

John W. Vinson

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.
 
R

raskew via AccessMonster.com

Hi -

Try <>"********". I tested this and it seems to do the job.

HTH - Bob
 
Top