Difference between dates (in days) month wise - MS Access 2007

[sahana16]

Hi all ,
I am using Access 2007

I have a table called "InsepctorLeaveDetails"

InspectorId |Startdate | Enddate

E1200 4/10/2013 4/25/2013


E1203 3/10/2013 3/25/2013
E1201 3/25/2013 4/10/2013

Desired o/p

InspectorId | InspectorName |Monthyear |vacation

E1200 Suraj April 2013 15
E1201 Damodhar April 2013 9
E1201 Damodhar March 2013 6
E1203 Shyam March 2013 15

If the months in STARTDATE & ENDDATE are different , the no.of days must be split according to respective months .
Please help me achieve this .

Thanks in advance .
Sahana

[AlexHedley]

You can use the
Day(Date)
Month(Date)
Year(Date)
Functions to get the different parts of a date.

E.g. Date = 1st May 2013
Day = 1
Month = 5
Year = 2013

To get the different between dates use the DateDiff Function.
DateDiff(interval, date1, date2)
DateDiff("d", ..., ...)

You can format text as well
Format(Date, "mmmm")
e.g. May
Or
DatePart("m", Date)

[AlexHedley]

You can find a tip at
http://www.599cd.com/tips/access/dat...y=AlexForumAFN