DaniWeb Forum Index > Search Forums

Search Results

•

Showing results 1 to 2 of 2
Search took 0.00 seconds. Search: Posts Made By: jwshepherd ; Forum: MS SQL and child forums

Save these search results for 24 hours

Forum: MS SQL

Aug 16th, 2005

Replies: 10

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

Views: 11,266

Posted By jwshepherd

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

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

Forum: MS SQL

Jun 16th, 2005

Replies: 10

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

Views: 11,266

Posted By jwshepherd

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

change the resulting variable to type double

Showing results 1 to 2 of 2