problem with CInt function

[stevem2004]

Hi,
I am using the CInt function for my database entries, this is not a problem, but this rounds all values to the nearest whole number, so if I have 126.75 in the database, then this is rounded to 127.

Is there any way to stop it rounding the numbers?

Thanks
Steve

[David Harrison]

Well Int stands for Integer, so no. CInt will round a number to the nearest integer, that's it's job if you like.

[buntine]

VB uses the Single datatype for floats. The Cast Single (CSng) function will be helpful.

CSng(expression) '| <-- Format.

Dim a
a = "22.3332"
CSng(a) '| <-- Example. (Should return 22.3332 or 22.33)

Also, VBScript has a rounding function.

Round(expression, numOfPlaces) '| <-- Format.
Round(2.1234, 2) '| <-- example. (will return 2.12)

That may be useful.

Regards.

[David Harrison]

What's the difference between CInt and Round?

[stevem2004]

Many Thanks Buntine, the CSng function works perfectly.

[buntine]

What's the difference between CInt and Round?

CInt will cast the expression to a whole Integer, thus removing any decimal places. Round gives you the option of keeping a certain number of decimal places. Round(2.333, 2) will return 2.33.

Regards.

[David Harrison]

Ah thank-you, that could prove useful.

[russell]

There is also a cdbl() function for floating point values...