If you 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

You should use a validation rule and the word "between" to require data entry in an Access database to fall between two dates. To do this, you would set up the validation rule for the field and use the keyword "between" followed by the two dates in the format #mm/dd/yyyy#. This will ensure that any data entered in the field falls between the two specified dates.

If You Require a Data Entry in an Access Database