Data type mismatch

K

Karl

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
 
B

BruceM via AccessMonster.com

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"
 
Top