hi,
i need to know for how long my student is learning at school.
in Excel i write in one cell the enter date and next cell the end date, for each student can have a several time periods.
my formula in Excel was like this:
=(A1-A2+A3-A4+A5-Now())/365.25
I.E: A1,A3,A5 - that enter dates, and A2,A4 its end dates - so my student in example start learn in A1 and end to learn in A2 and back to learn in A3 until A4 and learn from A5 untill now.
how i do this in access??
thank you,
miki