[alex]

Δάφνη καλησπέρα!!!!

Αντέγραψε τον κώδικα του ερωτήματος πιστεύω ότι είναι αυτό που ζητάς.Από αυτό το ερώτημα πάρε τις 3 συναρτήσεις από τα χρόνια , τους μήνες , και τις ημέρες.Αν δεν το καταφέρεις αναφερέ μου να κάνω κάτι άλλο.

SELECT Tblypiresia.ID, Tblypiresia.ΕΠΩΝΥΜΟ, Tblypiresia.ΟΝΟΜΑ, Tblypiresia.NameSchool, Tblypiresia.Thesi, 
Tblypiresia.StartDate, Tblypiresia.EndDate, IIf([StartDate] Is Null Or [EndDate] Is Null,"", 
DateDiff("yyyy",[StartDate],[EndDate])-IIf(Format([StartDate],"mmdd")>Format([EndDate],"mmdd"),1,0)) AS ΧΡΟΝΙΑ, 
IIf([StartDate] Is Null Or [EndDate] Is Null,"",IIf(Day([StartDate])<=Day([EndDate]),DateDiff("m",[StartDate],
[EndDate])-[ETH]*12,DateDiff("m",[StartDate],[EndDate])-[ETH]*12-1)) AS MHNEΣ, IIf([StartDate] Is Null Or 
EndDate] Is Null,"",DateDiff("d",DateAdd("m",[MHNES],DateAdd("yyyy",[ETH],[StartDate])),[EndDate])) AS 
HMEPEΣ, Tblypiresia.DegreeText AS Eκφρ8, IIf([StartDate] Is Null Or [EndDate] Is Null,"", 
DateDiff("yyyy",[StartDate],[EndDate])-IIf(Format([StartDate],"mmdd")>Format([EndDate],"mmdd"),1,0)) AS ETH,
 IIf([StartDate] Is Null Or [EndDate] Is Null,"",IIf(Day([StartDate])<=Day([EndDate]),DateDiff("m",[StartDate], 
[EndDate])-[ETH]*12,DateDiff("m",[StartDate],[EndDate])-[ETH]*12-1)) AS MHNES, IIf([StartDate] Is Null Or 
[EndDate] Is Null,"",DateDiff("d",DateAdd("m",[MHNES],DateAdd("yyyy",[ETH],[StartDate])),[EndDate])) AS HMEPES, 
(([ETH]/1*[Degree])+([MHNES]/12*[Degree])+ ([HMEPES]/365*[Degree])) AS Moriodotisi
FROM ([ΠΙΝΑΚΑΣ ΕΚΠΑΙΔΕΥΤΙΚΩΝ] INNER JOIN Tblypiresia ON [ΠΙΝΑΚΑΣ ΕΚΠΑΙΔΕΥΤΙΚΩΝ].ΕΠΩΝΥΜΟ = 
Tblypiresia.ΕΠΩΝΥΜΟ) INNER JOIN TblDegrees_T ON Tblypiresia.DegreeText = TblDegrees_T.DegreeText;