Using a "Like" statement, or just use a wildcard? 1

[mdweezer]

I have a form full of controls that will be used to trigger a report and based on the information on the form will determine which records show up on the report.
ex) type in the date due and reports with that due date show up, simple stuff =)

Anyway, 3 of my search criterias are text boxes that are 3 strings.

I know in mySQL there is a "like" function so I could find records where such and such a field is "like" string1.

The fields I am comparing to them I believe are memo's.

Whats the easiest way to do this?

Thanks in advance!

 

[PHV]

Something like this ?
sCriteria = "[memo field] Like '*" & Me![textbox] & "*'"
If the underlaying tables aren't ms-access you have to use % as wildchar instead of *

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mdweezer]

My result code that works like a charm!!!!

qry = qry & "WHERE (((TBL_Items.Item) LIKE '*" & TitleValue & "*'));"

Thanks a lot! You get a star!