Any combination of the following expressions can be used as criteria in your query.

 

Note that these criteria can also be used in the Record Source View for reports and labels.