G Guest Jul 7, 2004 #1 I'm trying to set up a field that will allow you to type in a number between 200 and 299, is there a way I can do this with my validation rule? Thanx!
I'm trying to set up a field that will allow you to type in a number between 200 and 299, is there a way I can do this with my validation rule? Thanx!
M M.L. Sco Scofield Jul 7, 2004 #2 In the field's Validation Rule property put: Between 200 And 299 Good luck. Sco gperson said: I'm trying to set up a field that will allow you to type in a number Click to expand... between 200 and 299, is there a way I can do this with my validation rule? Thanx!
In the field's Validation Rule property put: Between 200 And 299 Good luck. Sco gperson said: I'm trying to set up a field that will allow you to type in a number Click to expand... between 200 and 299, is there a way I can do this with my validation rule? Thanx!
L Lynn Trapp Jul 7, 2004 #3 To include 200 and 299 in the range use: = 200 And <= 299 Click to expand... To exclude them use: 200 And < 299 Click to expand... -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm gperson said: I'm trying to set up a field that will allow you to type in a number Click to expand... between 200 and 299, is there a way I can do this with my validation rule? Thanx!
To include 200 and 299 in the range use: = 200 And <= 299 Click to expand... To exclude them use: 200 And < 299 Click to expand... -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm gperson said: I'm trying to set up a field that will allow you to type in a number Click to expand... between 200 and 299, is there a way I can do this with my validation rule? Thanx!
