SELECT Tenant.TenantName, House.House, TenantPayment.TenantPaymentTypeID, TenantPaymentType.TenantPaymentType, TenantPayment.TenantPaymentDate, TenantPayment.TenantPaymentAmount, House.HouseOwnerID
FROM (TenantPayment LEFT JOIN TenantPaymentType ON TenantPayment.TenantPaymentTypeID = TenantPaymentType.TenantPaymentTypeID) INNER JOIN (Tenant LEFT JOIN House ON Tenant.TenantHouseID = House.HouseID) ON TenantPayment.TenantPaymentTenantID = Tenant.TenantID
WHERE (((TenantPayment.TenantPaymentTypeID)=1) AND ((TenantPayment.TenantPaymentDate)>=[Forms]![CommonData]![ReportFromDate] And (TenantPayment.TenantPaymentDate)<=[Forms]![CommonData]![ReportToDate]) AND ((House.HouseOwnerID)=5) AND ((House.HouseID)<>7))
ORDER BY House.House;