The criteria is the text, number or date you wish the search to locate based on the other conditions in the SQL statement.
Note the following SQL requirements:
Search strings should be enclosed by single quotes (‘text to search’)
Search dates should be enclosed by the pound sign (#12-23-99#)
See the topic Using SQL Statements for more information.