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.

first of all, see this (http://www.access-programmers.co.uk/forums/showthread.php?t=143346).

what you want will work with this:WHERE [street field] LIKE "*" & [parameter name] & "*"

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