Subtracting dates to equal months-access 2000

H

harvey

I need to calculate months based on separate dates. For example:
Start date End Date
2/14/04 9/4/05
1/1/05 Present date date()
I have rentals in family apartment house. I need to multiply months times
monthly rent to figure out total rent that was due. I do not know sql or
programming language. Can it be done using multiple queries or via form. I
am not a programmer or professional although I've used access 2000 since
2000.
 
P

PC Datasheet

Hi Harvey,

NumberOfMonths = DateDiff("m",Me!StartDate,Me!EndDate)

If you need help with your database, email me at my email address below.
 
Top