How to filter a table with...??

[Mirko]

Hi all!
My question is how to filter a access column with the
next task: I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix. Also the criteria is that field contains
*. The fields are diferent and have diferent strings like
+, -, etc.
TIA Mirko

 

[John Vinson]

Hi all!
My question is how to filter a access column with the
next task: I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix. Also the criteria is that field contains
*. The fields are diferent and have diferent strings like
+, -, etc.
TIA Mirko

This is a bit tricky because the LIKE operator - which lets you search
using wildcards, partial strings, etc. - uses * as a wildcard meaning
"match any string".

The solution is to use [] to indicate to Access that you are searching
for a literal asterisk: a query criterion of

LIKE "*[*]*"

will find records containing any number of characters (the first *), a
literal asterisk, and then any number of trailing characters.

 

[Tim Ferguson]

I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix.

In addition to John's solution, the other one is

WHERE INSTR(MyTextField, "*")>0

Hope that helps


Tim F