Thread: "Data Type Mismatch In Criteria Expression" Error
View Single Post
  #1  
Old November 9th, 2004, 01:24 PM
LB
external usenet poster
  
Posts: n/a
Default "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)