Problem with * in query

[C2680mor]

I have a database that gives lists of UK Attractions. There is a field that defines the companies on the database as either a Museum, Art Gallery or Other. It is shortened this so they enter "M" for Musuem, "A" for art gallery and "O" for other.

Some of the attractions have more than one definition, so may have both "M" and "A" in this field. They are also not in a defined order, so some may be "MA", others may be "AM". There are no spaces or punctuation between the letters.

I have assumed that to run a query to find all of the "M"s would use the "*", but this is not working. I have also tried the "?". It is not generating a syntax error, so I am not sure where I am going wrong.

I have tried
=*"M"*
=?"M"?
=*[M]*

any help is appreciated, thanks,

Chris

 

[ColinEssex]

To find the M's put

Like "M" & "*"

in the query criteria

Col

 

[SQL_Hell]

Hi,


Use LIKE instead of equals

If I remember correctly it should be


WHERE field1 LIKE 'M*'

 

[SQL_Hell]

Damn beaten to it

 

[C2680mor]

New it would be simple, thanks for the help.