Access 2007 expressions

[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?

 

[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.