[kapetang]

Τελικά κατέληξα στα παρακάτω

SELECT Pelatologio.*, Eortes3imero.Κείμενο15 AS ΗΜΕΡΟΜΗΝΙΑ
FROM Pelatologio, Eortes3imero
WHERE (((InStr(" " & Replace(Replace(UCase([Eortes3imero]![ONOMASIA]),")",",)")," (",",( ")," " & [Pelatologio]![ONOMA] & ","))>0));

SELECT Pelatologio.*, EortesSimera.Κείμενο15 AS ΗΜΕΡΟΜΗΝΙΑ
FROM Pelatologio, EortesSimera
WHERE (((InStr(" " & Replace(Replace(UCase([EortesSimera]![ONOMASIA]),")",",)")," (",",( ")," " & [Pelatologio]![ONOMA] & ","))>0));

Όλη η φασαρία γίνεται για να συγκρίνονται ολόκληρα ονόματα.