Help with Dates & values

[Mia101]

Hi there,
I have a table with a start date and an end date for a leasing database. The lease has an annual fee, but I want to calculate what's that worth for each month of the duration of the lease.

Is this possible through a query?
I was going to store this data, but having read some of the other posts here, have decided it's not the best option - as I only need these values for reports/queries.

Any help would be greatly appreciated, as I am very rusty on Access at the moment.
Thanks,
Mia.

 

[neileg]

Mmm... Isn't the monthly fee the annual fee divided by twelve?

Or, if you have the total value of the leasing payments, you can find the number of months in the whole lease by using DateDiff() on the start and end dates. Divide the total cost by that.

 

[Mia101]

Yes, I guess what I'm really asking is how would you calculate it for the start/end months, if for example the lease began on the 15th of the month, and in a 30-day month there would be 16 billable days...

Sorry for not specifying & thanks for your help!

 

[neileg]

Use DateDiff() to calculate the number of days between the month end and the start/end date.