Specific filter for the data in a field

  • Thread starter Thread starter Dimitris
  • Start date Start date
D

Dimitris

Hello,

In a field there are entries that have the symbol * entered for some reason.
For example:
DBW*R2
3*FLEW
QQ*IF94

How can I filter and find all the data in that field that has "*" entered. I
can't seem to find the filter for it.

Thanks
Dimitris
 
On Wed, 3 Feb 2010 14:29:28 +0200, "Dimitris" <[email protected]>
wrote:

Use this expression:
Like "*[*]*"

This means a wildcard followed by an asterisk followed by a wildcard.

-Tom.
Microsoft Access MVP
 
Back
Top