query expression

[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!

 

[Marshall Barton]

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.

 

[christine t.]

Thank you very much for the help - it worked perfectly!!!
Happy New Year
--
c.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.

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.