|
-
Feb 2nd, 2008, 08:49 AM
#2
Re: data type Mismatch in criteria expression
Just like in VB code, the error "Data type mismatch" in SQL statements means that you are trying to put a value of one data type (eg: String/Date/Integer/...) into something which has a different data type - but the value cannot fit into the other data type.
Check what data type the "Plot" field is in that table, and then make sure that you have specified the value appropriately - as shown in the article How do I use values (numbers, strings, dates) in SQL statements? from our Database Development FAQs/Tutorials (at the top of this forum)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|