Set RsR = db.OpenRecordset( _
 & " SELECT DISTINCTROW Postleitzahlen.*," _
 & "    Adressen.*, " _
 & "    Firmen.*, " _
 & "    Rechnungen.* " _
 & "  FROM (((Rechnungen " _
 & "    INNER JOIN Uebergabestellen " _
 & "        ON Rechnungen.ID_Uebergabestelle =" & _
 "Uebergabestellen.ID_Uebergabestelle) " _
 & "    INNER JOIN Firmen " _
 & "        ON Uebergabestellen.ID_Firma = Firmen.ID_Firma) " _
 & "    INNER JOIN Adressen " _
 & "        ON Firmen.ID_Firma = Adressen.ID_Firma) " _
 & "    INNER JOIN Postleitzahlen " _
 & "        ON Adressen.ID_PLZ = Postleitzahlen.ID_PLZ;", dbOpenDynaset)

Gru?
SR