query expression

  • Thread starter Thread starter christine t.
  • Start date Start date
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!
 
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.
Click to expand...


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.
 
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.
Click to expand...


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.
Click to expand...
 
Back
Top