Paramater type query

[JGarcia2k32000]

I have a column in my table that has anywhere between 100-200 characters. What I'm trying to do is like a parameter query where the user prompts in what they are searching for, (Example, find "Washington, George"). What I need displayeds is all the instances of that name in that column.

Thanks,
Juan

 

[rockman]

Try using the LIKE operator.

Criteria: LIKE "*" & [SearchString] & "*"

Hope this helps,
Jeff

 

[JGarcia2k32000]

Like a glove man, thanks