I USED THIS CODE IN SQL
DATEDIFF(DAY, TOS, GETDATE())/30 AS TEN
WHAT CAN BE USED IN ACCESS DATA SOURCE
i used this code and it works
SELECT PersData.PNO, PersData.RANK, PersData.Name, PersData.DOSEN, PersData.UNIT, PersData.APPOINTMENT,PersData.FROM, PersData.SPECI,PersData.COURSESTR,DateDiff('d', [PersData.FROM], Now()) / 30 AS TEN FROM PersData
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.