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 In Criteria Expression" Error
Please see query statement below:
String$(1,40) & Left$([SQLIS_PROVMISC]![FAXNBR],3) & String$(1,41) & Space$(1) & Mid([SQLIS_PROVMISC]![FAXNBR],4,3) & String$(1,45) & Right([SQLIS_PROVMISC]![FAXNBR],4) |
#2
|
|||
|
|||
Hi,
My guess is because the [SQLIS_PROVMISC]![FAXNBR] is null. "LB" wrote: Please see query statement below: String$(1,40) & Left$([SQLIS_PROVMISC]![FAXNBR],3) & String$(1,41) & Space$(1) & Mid([SQLIS_PROVMISC]![FAXNBR],4,3) & String$(1,45) & Right([SQLIS_PROVMISC]![FAXNBR],4) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Arithmetic overflow error converting numeric to data type numeric | eddiec | General Discussion | 2 | November 1st, 2004 09:24 AM |
When I try to change the data type I get an error that there isn'. | KIKI | General Discussion | 1 | September 29th, 2004 04:06 AM |
Data type mismatch in criteria expression | Paul James | Running & Setting Up Queries | 5 | September 8th, 2004 01:13 AM |
data type mismatch error | Praveen Manne | Using Forms | 3 | June 30th, 2004 11:02 PM |
Complicated issue re 'Type mismatch in JOIN expression' | Adam | General Discussion | 10 | June 14th, 2004 09:39 AM |