RSS

Re: How to get the result for smaller number divide larger number?

Please support our MS SQL advertiser: Programming Forums

How to get the result for smaller number divide larger number?

•

Join Date: Jun 2005

Location: Texas

Posts: 120

Reputation: jwshepherd is an unknown quantity at this point

Rep Power: 4

Solved Threads: 5

jwshepherd jwshepherd is offline

Offline

Junior Poster

Aug 16th, 2005

try doing your calculations before your sql statment

Dim i As Double
Dim MySql as string 
i = 50 / 100
Mysql="Select " & i & " FROM table;"
rs.open MySQl,conn,3,3,1

.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf