Newbie: help with Round() function

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,
I am using the round function since i wan two decimal places and it doesnt
give me the correct results.
The field in which i apply it is a Real.
So in my querries I have something like:

value1 = 2.3443 and Round(value1,2) = 2.3443 *instead of* 2.34

The funny thing is that I tried it on a copy of the database on SQL Server
and I get the *same* result !!!!...

Is it because I have a fench copy of XPÉ I have changed my regional settings
to English.

PLEASE HELP!
TIA
-steve
 
Maybe you try this

dim str as string
dim val as double

val=2.3443
str=format(val,"Standard")


- Raoul
 
Back
Top