Hello,
I am new to access and need some help.
I am trying to use the Between [Enter first number] And [Enter last number] query command. I want access to determine if the two numbers or out of range. For example, if the difference is greater than 10, return an error. So 0-10 would work but not 0-11. Also, if the last number is smaller than the first number return an error (10-0 vs 0-10).
I am so unfamiliar with access. Any help would be great!