Query Criteria for Numeric Fields in MS Access - Office 365

You can define different criteria on Numbers, Currency and AutoNumber fields. You can retrieve records with matching value, not matching value, use comparison operators like greater than, less than, greater than or equal to or less than or equal to. You can retrieve from a specific set of values or use in between as well. You can also use asterisk to retrieve like values from the table.