Getting results that contains input value

[Brian Wetherell]

Heyas;

I have a query that asks the user to input the address
NUMBER, and what it is supposed to do is to output any
addresses that contain that number. For example, if I
input the number "100" in the prompt, it should give me
any addresses whose street number that contains "100" even
if it is 1001. Unfortunately I dont get any results,
because MSAccess looks for any records with that unique
value. Therefore, "100 hedgewood ln." and "1001 Main st."
will not show up. How can I get this query to get the
output i need? I'm on a serious deadline, and I'm stumped.

 

[John Spencer (MVP)]

Try something like the following as your criteria

Field: Address
Table: YourTableName
Criteria: LIKE "*" & [Find What] & "*"

That should find any address that contains what you enter when the parameter
dialog pops up.