How it works
Lets now multiply 343.12345678 by 10^2. 10 is the decimal and the 2 is how many we need to move.
You should get 34312.345678. Now if you use the round function you will get 34312 right?
So now that we have all the correct numbers we need to get the number back to the right value. 34312 is way bigger than 343.12. So we now divide 34312 by 10^2 again. The result is 343.12.
You are now able to round any number to a certain amount of decimal points.
If you are migrating over to Windows 7 and running 64bit there may be some issues when trying to use 32bit ODBC drivers.
Step 1. Navigate to c:\Windows\SysWOW64\ directory
Step 2. Run odbcad32.exe
From here you will be able to configure your ODBC DSN.
- ► 2016 ( 13 )
- ► 2014 ( 14 )
- ▼ 2012 ( 7 )