View Single Post
  #1  
Old February 16th, 2010, 04:38 PM posted to microsoft.public.access.gettingstarted
Karl
external usenet poster
 
Posts: 274
Default Data type mismatch

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