Search Field to find addresses in a report

[evilcowstare via AccessMonster.com]

Hi, I am working with a database that has already been created and in use,
they used a single box for all address info which does not have an address ID
of any sort, it is just a standard field within a main job.

The addresses are therefore duplicated if another job comes in and often have
the number in front i.e 23 Smith Street.

Is there anyway I can create a search box which will search for ANY words
within a field rather then start from the first so for example if it were 189
Smith Street, I could just put Smith and it would bring up all jobs where in
the address field the word Smith appears in a report?

Im not great with codes so please try to explain what I need to do if you
dont mind and can spare a couple of mins

Thank You !!!!!

 

[KARL DEWEY]

In design view of your query use criteria for Address field --
Like "*" & [Enter street name] & "*"

 

[evilcowstare via AccessMonster.com]

Thank you Karl, I will give it a go

In design view of your query use criteria for Address field --
Like "*" & [Enter street name] & "*"

Hi, I am working with a database that has already been created and in use,
they used a single box for all address info which does not have an address ID

[quoted text clipped - 12 lines]

Thank You !!!!!