Validation arguments

[Guest]

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.L. Sco Scofield]

In the field's Validation Rule property put:

Between 200 And 299

Good luck.

Sco

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!

 

[Lynn Trapp]

To include 200 and 299 in the range use:

= 200 And <= 299

To exclude them use:

200 And < 299

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

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!