Parameters That Use Wildcards 2

[davemib]

how can i make a query that will use a Parameters and a wild card

parameter = insert contact details

wild could shhould be able to search any part of a name.

 

[TonyJollans]

Hi davemib,

Use ..

[blue][tt]WHERE YourField LIKE "*" & [Enter Contact Details] & "*"[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[davemib]

thanx i'll try it out

 

[davemib]

nah i tried it and it didnt work - would u mind sending me a sample of it.

 

[EliseFreedman]

Here is an example taken from one of my databases

SELECT customers.name
FROM customers
WHERE (((customers.name) Like "*" & [Forms]![FindAlias].[combo0] & "*"));

 

[TonyJollans]

Hi davemib,

I'd rather explore more here in the forum if you don't mind.

1. Exactly what did you try and fail with? What did you enter, and where, and what was the result?

2. Do you want Users prompted for the parameter, or it taken from a Form (as in Elise's example)

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[davemib]

when u normally input a parameter u put it in like:

[Enter Contact Details]

but when i tried ure example tony in the query builder it dont seem to work - none of the results appear?

Where [Table1]![Name] Like "*" & [Enter Contact Details] & "*

 

[TonyJollans]

Hi davemib,

My apologies if I'm stating the obvious here, but what I posted is part of an SQL statement.

If you are putting it in the Criteria in the Query builder you just want to use ..

[blue][tt]Like "*" & [Enter Contact Details] & "*"[/tt][/blue]

.. and Access fills in the rest in the generated SQL.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[davemib]

great! it worked thanx Tony!