"Data Type Mismatch In Criteria Expression" Error

L

LB

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
type mismatch error in macro in excel 0
Data type mismatch in criteria expression issue 2
Data type mismatch error 2
Data Type Mismatch in Criteria Expression 4
data mismatch 2
data type mismatch 4

Top