"Data Type Mismatch In Criteria Expression" Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top