Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

math formula generates overflow error

Status
Not open for further replies.

mikecoal

Programmer
Nov 7, 2001
8
US
here is the formula that i am getting an error with

MP = LA * (r / (1 - (1 / ((1 + r) ^ MONTHS))))

LA is retrieved from SQL as char same with MONTHS
could this be the problem? if so how do i convert the char values to numeric to perform the formula?
 
r > 0
it may be a decimal or a whole number depending on what other data is enterd

I figured it out though
the way i called the data was wrong
the difference between
r = recordset1.field("r")
and
r = recordset1.field.item("r")

difference between char and dec in ASP math i guess
but it worked

thanks for your time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top