If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Data type mismatch
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 |
Thread Tools | |
Display Modes | |
|
|