search using wildcard

[ekses90]

i want to search something like yy in this xxxx/yy/xxxx.
so i imagine the sql using wildcard is like below.
SELECT * FROM place WHERE id LIKE '_ _ _ _ _ y y _ _ _ _ _';

but i want to make "y y" is a keyword that i key in.
can anyone tell me how to do that?

 

[John Big Booty]

In your query criteria use;

Like "*" & "Y Y" & "*"

Now if you want "Y Y" to be keyed in from a form field you can use;

Like "*" & Froms!YourFormName!YourFieldName & "*"

 

[Brianwarnock]

ekses90
I assume that you spotted John's typo Froms! should be Forms! he probably was testing that you were awake.

Brian

 

[jdraw]

There is a free video tutorial here for setting up a general search form.
Well worth watching..

http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[John Big Booty]

ekses90
I assume that you spotted John's typo Froms! should be Forms! he probably was testing that you were awake.

Brian

Ah yes, spot the obvious mistake Don't you just hate those little fingergraphical errors, they can keep you busy for hours trying to spot them