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
Ofer Cohen said:
Try
Round([MyNumber],2)
Or
Format([MyNumber],"#.00")
--
Good Luck
BS"D
smorg said:
converting data in queries I am trying to convert from standard number to 2
place decimals number have tried rnd cdec with no luck
