Data type mismatch

Karl

Guest

Posts: n/a

16th Feb 2010

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

« Error Message after exporting MS Access Table | how to view 2 tables in design view side by side (access 2007) »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Type Mismatch in Expression - can I force a query to read as a diferent data type?	S Davis	Microsoft Access Queries	1	7th Jun 2007 11:33 PM
System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.	psychomad	Microsoft ASP .NET	2	10th Apr 2007 08:31 PM
Data type mismatch	=?Utf-8?B?anVkeWJsdWU=?=	Microsoft Access Queries	4	29th Jun 2006 08:21 PM
Data Type Mismatch	=?Utf-8?B?RGlv?=	Microsoft Access	0	20th Jun 2006 08:59 AM
SQL Help, Data Type Mismatch	thspimpolds@gmail.com	Microsoft Access	2	12th Dec 2005 05:33 PM