Prev: cursor changes to hand when focus on label
Next: Delete Query
From: Dimitris on 3 Feb 2010 07:29
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


From: Tom van Stiphout on 3 Feb 2010 08:47
On Wed, 3 Feb 2010 14:29:28 +0200, "Dimitris" <ipackREMOVE(a)otenet.gr>
wrote:

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

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

-Tom.
Microsoft Access MVP


>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
>
 | 
Pages: 1
Prev: cursor changes to hand when focus on label
Next: Delete Query