If you want to require a data entry in an Access database to fall between two dates (rather than between two numeric values):
A)You should use a select query using one line
B)You should use a select query, using two lines
C)You should use a validation rule and the word "between"
D)This is impossible to require in Access

Question

Quizplus · Accepted Answer

In Access, to require a data entry to fall between two dates, you would use a validation rule with the word "between". This allows you to specify a range that the data must fall within, including dates.

If You Want to Require a Data Entry in an Access