Is there a way to include wildcards in MS Access parameter queries?

[Linty Fresh]

I have a table with a string field for a street. It might have data such as:

Bleeker Street
or Bleeker St.

I want to create a query that will enable the user to search for a string by entering a parameter. Is there a way to construct a query using wildcards for a string so that if the user types in "Bleeker" both the above values will be returned?

Thanks.

 

[ajetrumpet]

first of all, see this.

what you want will work with this:

WHERE [street field] LIKE "*" & [parameter name] & "*"

 

[apr pillai]

wildcards

use single quotes before and after * - LIKE "'*" & [parameter name] & "*'"