How do I create a complex search query?

S

Sacred

I'm not sure what to put in the title but ill explain my problem.
In the Criteria:
Like "*Cher*"
Click to expand...

I tried that and it came back with an invalid syntax error can you explain
why?

Like "*Cher*" [Enter Street Name]

Also if I was to do that this would only be valid for searches containing
"Cher", If I wanted to speed up a search while looking for "Green Lane" that
Wouldn’t help.

I need the query to automatically search without it needing to be given the
full entry in the field, it also needs to be able to work across different
data so I don’t think the above would work.

Regards,
Sacred
 
T

Tom Wickerath

Use the criteria:

Like "*" & [Enter Street Name] & "*"

for the field that holds the street address data.


Tom
____________________________________________

In the Criteria:
Like "*Cher*"
Click to expand...

I tried that and it came back with an invalid syntax error can you explain
why?

Like "*Cher*" [Enter Street Name]

Also if I was to do that this would only be valid for searches containing
"Cher", If I wanted to speed up a search while looking for "Green Lane" that
Wouldn’t help.

I need the query to automatically search without it needing to be given the
full entry in the field, it also needs to be able to work across different
data so I don’t think the above would work.

Regards,
Sacred
 
S

Sacred

Thank you very much has solved my problem.

Regards,
Sacred

Tom Wickerath said:
Use the criteria:

Like "*" & [Enter Street Name] & "*"

for the field that holds the street address data.


Tom
____________________________________________

In the Criteria:
Like "*Cher*"
Click to expand...

I tried that and it came back with an invalid syntax error can you explain
why?

Like "*Cher*" [Enter Street Name]

Also if I was to do that this would only be valid for searches containing
"Cher", If I wanted to speed up a search while looking for "Green Lane" that
Wouldn’t help.

I need the query to automatically search without it needing to be given the
full entry in the field, it also needs to be able to work across different
data so I don’t think the above would work.

Regards,
Sacred
Click to expand...
 
Top