MySqlText = "SELECT k.DokNr FROM Korrespondenz k WHERE k.BausparNr='" & _
  lstrBSNR & "' and k.KorrNr='" & mdlKorr & "'"
MySqlText = MySqlText & " and k.DokNr in (select s.DokNr from Scandokumente s" & _
"where  convert(char(8), s.arcdatum,4)='" & mdlDatum & "');"
 
"SELECT k.DokNr FROM Korrespondenz k WHERE k.BausparNr='100543036 ' and" & _
  "k.KorrNr='GV09' and k.DokNr in (select s.DokNr from Scandokumente s where " & _
  "convert(char(8), s.arcdatum,4)='12.09.03');"