SELECT tblDaten.regdate AS Eingangsdatum, tbliMK.serienr AS SerieNr, _
  tblDaten.repnr AS RMA, tbliMK.matnr AS MaterialNr, tbliMK.maschinentyp, _
  tbliMK.imktyp, tbliMK.vertretung, tbliMK.kunde, tbliMKFehlertable.name AS _
  Fehlerursache
FROM ((tblDaten RIGHT JOIN tbliMK ON tblDaten.id = tbliMK.matid) LEFT JOIN _
tbliMKFehler ON tbliMK.matid = tbliMKFehler.matid) LEFT JOIN tbliMKFehlertable _
ON tbliMKFehler.fehler = tbliMKFehlertable.id
WHERE (((tbliMK.serienr)>'1.03.050.0000' And ( _
tbliMK.serienr)<'1.03.100.9999') OR ((tbliMK.serienr)>'1.02.050.0000' And ( _
tbliMK.serienr)<'1.02.100.9999'))
AND ((tbliMK.matnr) Like '304*000*56300' OR (tbliMK.matnr) Like '304*000*54200' _
OR (tbliMK.matnr) Like '304*001*52300')
AND ((tbliMK.imktyp) Like 'O30' OR (tbliMK.imktyp) Like 'C20' OR ( _
tbliMK.imktyp) Like 'C15' OR (tbliMK.imktyp) Like 'C15 / F23')
AND ((tbliMKFehlertable.name) Like 'Spulraum -> ungetestet liquidiert' OR ( _
tbliMKFehlertable.name) Like 'Basis C: C7 Kurzschluss')
ORDER BY tbliMK.serienr;