Wild Card Search

[kbreiss]

I am having trouble using the Like statement. It won't retreive any results. However if I change the "Like" to "=" and take out the '* this query works fine.

SELECT *
FROM [DUI Speakers]
WHERE Event Like '*[Forms]![frmSchoolInfo]![txtEvent]*';

Anybody have any ideas why this wouldn't return any results?

Thanks,
Kacy
________
LovelyWendie

 

[sportsguy]

SELECT *
FROM [DUI Speakers]
WHERE Event Like '*'&[Forms]![frmSchoolInfo]![txtEvent]&'*';


try this

sportsguy

 

[kbreiss]

that did it....Thanks!
________
Concept X1