There are some built in MS Access query functions to help you set more criteria. These functions apply to different field types. There are some for Date field, Text field, Number fields, etc. Some of these functions include the Between, Year, DatePart, DateSerial, DateAdd, etc. Most times they are combined with AND, OR, etc.

There are many of them but in this part 3 of this MS Access tutorial chapter (chapter 4), I will now list about 16 of these expressions below with the fields they can be applied to, their expression and then their descriptions.

This is the part 3 of chapter 4 of the MS Access tutorials.
You are advised to study part 1 of chapter 4: INTRODUCTION TO QUERIES IN MICROSOFT ACCESS 2013 AND 2016 at http://www.microsofttut.com/2017/03/introduction-to-queries-in-ms-access-2013-2016.html

Or study part 2 here at http://www.microsofttut.com/2017/03/methods-of-filtering-database-in-ms-access.html

You can take a look at the previously treated chapters in this MS Access tutorial at http://www.microsofttut.com/p/course-content-for-microsoft-access.html.

The table or database from which we will draw our reference is shown below.

EXPRESSIONS THAT CALCULATE DATE AND ALSO USE THE RESULT AS CRITERIA
1. FIELD: PREDICTED REG DATE
EXPRESSION: Between Date() And DateAdd("m",2,Date())
DESCRIPTION: This expression displays records of Student’s whose Registration date fell between today’s date and two months from today’s date.

2. FIELD: REG DATE
EXPRESSION: <Date()-20
DESCRIPTION: This expression displays the records of students whose registration dates are less than 20 days old.

3. FIELD: REG DATE
EXPRESSION: Year([REG DATE])=2016
DESCRIPTION: This expression displays the records of students that registered in the year 2016.

4. FIELD: REG DATE
EXPRESSION: DatePart("q",[REG DATE])=3
DESCRIPTION: This expression displays the records of students that registered in the third quarter of the calendar.

5. FIELD: REG DATE
EXPRESSION: DateSerial(Year([REG DATE]),Month([REG DATE])+1,1)-1
DESCRIPTION: This expression displays the records of students that registered on the last day of the month.

6. FIELD: REG DATE
EXPRESSION: Year([REG DATE])=Year(Now()) And Month([REG DATE])=Month(Now())
DESCRIPTION: This expression displays the records of students that registered in the current year and month.

EXPRESSIONS THAT USE TEXT AS CRITERIA
Click http://www.microsofttut.com/2017/03/some-special-query-functions-in-ms-access-applications.html to read full post with screen to screen ilustration images.