A range check that can be used in Microsoft access to calculate the data collected which is date and time

A range check is often used when a person works with data consisting of numbers, dates and times, or currency, ensuring that a number is within a specific range.

Explanation:

Range checks allow a person to set suitable boundaries. In microsoft (example) : Accept letters (a - z) only : Is Null OR Not Like "*[!a-z]*" : Any character outside the range A to Z is rejected. (Case insensitive.)An example of a range check is checking to see if the value of a 16-bit integer is within the capacity of a 16-bit integer. When a range check is performed, upper and lower boundaries are specified.Range check is a validation check which can be applied to numeric fields. This is done to ensure that only numbers within a certain domain can be entered into a field. Remember that this does not necessarily mean that the data entered will be correct. But it will certainly lie within reasonable limits.A method of validation which checks that data falls between an upper and lower acceptable value.