Access 2007 expressions

R

ralphz

I have previously used expression; Like "*" & [Find What] & "*" in the
criteria field of a query to return records for a keyword search. Worked
fine in 2003 version but not 2007. Any suggestions for an alternative
expression that works in 2007 would be most welcomed?
 
D

Douglas J. Steele

It depends on how you're using the query.

Try changing to

Like "%" & [Find What] & "%"

and if that doesn't work, tell us how you're using it.
 
Top