query expression

C

christine t.

In my table are fields containing "*******". I'd like to filter these
records out in a query with an expression but nothing I've tried works.
Thanks in advance for your help!
 
M

Marshall Barton

christine said:
In my table are fields containing "*******". I'd like to filter these
records out in a query with an expression but nothing I've tried works.


How many fields have that?

Do you want to skip the records that have that in any of
those fields or only skip them if all those field have that?

Either way, the criteria:
Like "*[!*]*"
will be true for a field that has anything other than all
astericks.
 
C

christine t.

Thank you very much for the help - it worked perfectly!!!
Happy New Year
--
c.t.


Marshall Barton said:
christine said:
In my table are fields containing "*******". I'd like to filter these
records out in a query with an expression but nothing I've tried works.


How many fields have that?

Do you want to skip the records that have that in any of
those fields or only skip them if all those field have that?

Either way, the criteria:
Like "*[!*]*"
will be true for a field that has anything other than all
astericks.
 

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

Top