wildcards in SQL statements

[Phil_L]

How do i put a wildcard in the following SQL statement? I want the returned data to include every entry that includes what i type in the query, whether before it or after it. I would imagine this uses "*"

[Type]=Forms![Advanced Search Form]!Type

Cheers,

Phil_L

 

[Mile-O]

Type] Like "*" & Forms![Advanced Search Form]!Type & "*"

 

[Phil_L]

This comes up with a dialog box saying 'syntax error (missing operator) in query expression

 

[Phil_L]

Sorry, working now!

Cheers

Phil

 

[Mile-O]

the square bracket on the leftmost side I accidentally clipped...