Counting Months

[Dan W. Hayden]

I am setting up a customer account file and need to know
how to have Access calculate a current account balance.
The calculating of the current number of months is the
area i need some help with. Customers pay a monthly fee
for service, need to know as of current date how much
money is due on the account (thus, if they signed up in
January and todays date is March 1, at $30.00 per
month,their current balance would be $90.00 minus any
paid amounts).


Customer Name
Date of Service
Monthly Fee
Monthly Payment
Current Balance

 

[Roger Carlson]

Look at the DateDiff function. It allows you to find the difference between
two dates in terms of seconds, minutes, hours, days, months, years,
quarters, etc. Something like this

DateDiff("m", Date, [StartDate])

The only case where this may be a problem is how you define when a new month
begins. You'll need to test it when exactly a month has passed.