converting or formatting months to numbers - Access 2000 Non Exper

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed) with
estimate of your
rates or how you charge. I'll prepay.
 
convert the month different to number and then multiply

Cint(formula to calculate date Different in month) * [Rent amount]
 
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
 
Back
Top