From: Karl on
New to Access 2007

I'm putting together a database. One of the fields is test scores which
have a value of 0 through 100 OR "ND". They aren't willing to get rid of the
"ND", so I have the field set to "Text".

Is there a way to create a validation rule that limits input to these
values? A combo box with 100+ values seems awkward.

I tried:

Between 0 and 100 OR "ND" but I got a type mismatch error.

Thanks
From: BruceM via AccessMonster.com on
This worked in Access 2003 as the validation rule for the control:
="ND" Or (>=0 And <=100)

For reasons I cannot figure out this (including several variations) did not
work:
(>=0 And <=100) Or "ND"

Karl wrote:
>New to Access 2007
>
>I'm putting together a database. One of the fields is test scores which
>have a value of 0 through 100 OR "ND". They aren't willing to get rid of the
>"ND", so I have the field set to "Text".
>
>Is there a way to create a validation rule that limits input to these
>values? A combo box with 100+ values seems awkward.
>
>I tried:
>
> Between 0 and 100 OR "ND" but I got a type mismatch error.
>
>Thanks

--
Message posted via http://www.accessmonster.com