converting or formatting months to numbers - Access 2000 Non Exper

H

harvey

I subtract two dates to get months difference using mm format in design
tables. Example: 9/4/05 - 1/1/05 = 09 months. I now want to multiply months
times [rent amount] to get total rent. Example 09 months times $1500 equals
$13,500.

Problem: Apparently I can't multiply months which is date format by an
integer.
Question: What's the best solution for a) query; b) forms.
I don't know sql nor programming language. If it's simple, I appreciate your
help. If complicated, please email me at [email protected] with
estimate of your
rates or how you charge. I'll prepay.
 
O

Ofer

convert the month different to number and then multiply

Cint(formula to calculate date Different in month) * [Rent amount]
 
R

Ricky Hicks MVP

You should use the DateDiff() function to return the elapsed months between
the 2 date values ..
This result will be a numeric value that can be used in your calculation ...

R. Hicks
 
Top