Field criteria happens to be a wildcard - "*", what to do?

[Guest]

Hi,

The table has a field that contains a star (*), which probably also is a
wildcard in Access language.

Anyhow, I want to use the star as a field critera, but not very surprising
it doesn't work as intended... instead of ONLY showing records with a stat
(*) it shows ALL RECORDS.

Is there a way to tell Access that "*" really means that, and not a wildcard?

Kindly,
Mikael L
Sweden

 

[Douglas J. Steele]

Try putting square brackets around the asterisk:

WHERE MyField = "[*]"

 

[John Spencer]

It sounds as if you are using LIKE rather than = as the search operator.

If you are using the query grid and type * into the criteria, Access will
assume that you want to use a wild card search. If you type = "*" then the
query grid will retain the equal sign for the comparison operator. Another
way to handle this is to type Like "[*]" into the grid. Placing the square
brackets around the wildcard tells the Like operator to treat the wild card
character as the character itself and not as a wild card.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..