Access 2007 expressions

  • Thread starter Thread starter ralphz
  • Start date Start date
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?
 
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.
 
Back
Top