Counting Months

[Theresa]

I volunteer for a not-for profit company.

I keep the database. I have a field for the date they
began - mm/dd/yyyy

i need to count the number of months they have been a
participant, from today.

How can I do that? I have a function for the number of
years

Length of Participation: DateDiff("yyyy",[DateBegan],Date
())-IIf(Format([DateBegan],"mmdd")>Format(Date
(),"mmdd"),1,0)


thanks

 

[Graham R Seach]

Theresa,

Use the same formula. Just tweek it a little:
Length of Participation (Months): DateDiff("m",[DateBegan],Date())- _
IIf(Format([DateBegan],"dd")>Format(Date(),"dd"),1,0)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html