Internet Search

Query criteria

This is only 20 most common criteria used in Access queries

Criteria for all data types: 

  1. Is Null : Searches for empty fields
  2. Is Not Null : Searches for non-empty fields
  3. Not in ("x") : Searches for all values except those equal to x
  4. "x" : Searches for values equal to x

Criteria for text:

  1. Like "*x*" : Searches for all values that contain x
  2. Not like "*x*" : Searches for all values except those that contain x
  3. Like "x*" : Searches for all values beginning with x
  4. Like "*x" : Searches for all values ending with x
  5. >= "x" : Searches for all values that come after x in alphabetical order
  6. <= "x" : Searches for all values that come before x in alphabetical order

Criteria for numbers:

  1. Between "x" and "y"  : Searches for values in the range between x and y
  2. < x : Searches for all values smaller than x
  3. <= x : Searches for all valuessmaller than or equal to x
  4. > x : Searches for all values larger than x
  5. >= x : Searches for all values larger than or equal to x

Criteria for dates:

  1. Between "#mm/dd/yy#" and "#mm/dd/yy#"  : Searches for dates that fall between two dates
  2. <#mm/dd/yy# : Searches for dates before a certain date
  3. >#mm/dd/yy# : Searches for dates after a certain date
  4. =Date() : Searches for all records containing today's date
  5. <=Date()-x : Searches for all records containing dates x or more days in the past

More info at: https://support.office.com/en-us/article/examples-of-query-criteria-3197...