decimal places

[Guest]

converting data in queries I am trying to convert from standard number to 2
place decimals number have tried rnd cdec with no luck

 

[Guest]

Try

Round([MyNumber],2)

Or
Format([MyNumber],"#.00")

 

[Guest]

thanks but the round does not round and format returns a string however
fix[number]*100/100 has done the trick. I have access 2002 and I have just
converted several databases from access 97 and many of the queries I had do
not work

Try

Round([MyNumber],2)

Or
Format([MyNumber],"#.00")

--
Good Luck
BS"D

converting data in queries I am trying to convert from standard number to 2
place decimals number have tried rnd cdec with no luck

 

[Jamie Collins]

have tried rnd cdec with no luck

The CDEC function is broken in Jet 4.0 and although some Jet 4.0 bugs
have been fixed in the Access 2007 engine this is not one of them.

In Jet 4/Access2007 engine, native decimal values are considered to be
DECIMAL in nature. DECIMAL has a higher order than the integer exact
numeric types and the approximate numeric types (REAL/Single and
DOUBLE) and therefore you can coerce a value to DECIMAL by operating on
it using a DECIMAL e.g.

SELECT TYPENAME(CDbl(2 / 3) + 0.00001 - 0.00001)

Jamie.

--