You can define different criteria for date fields in query. You can retrieve records with a matching date, not matching with a date, less than or greater than a date, between two dates, matching only specific dates etc. You can use datepart function to retrieve part of a date (like year, month, day) and compare to retrieve records from table. This video explains all different ways you can retrieve data from a table by applying different criteria on date fields in MS Access.