Search results

Thanks John I read the other posts. I tried the % sign and it works. I also from the Tools/options did untick the SQL Compatiblity checkbox but it still changes back to the ALike Name. I even closed the Database and reopen the database. Thanks BBryan

Hi, I have converted a 2003 Database to 2007 All my Querys that had used the Like operator (Example Like [forms]![frmEmployees]![txtLastNameFilter] & "*") automaticly have changed to the word ALike (Example ALike [forms]![frmEmployees]![txtLastNameFilter] & "*")and query doesn't work. I...