The "right,3" function

[Payal Patel]

Hi,
I am trying to run a query that does the following: I want to bring in only the three characters to the right of a number field from a table. So if it is 35.25, I want it to bring in .25 The problem is when I try to bring in something like 30.90, it brings it in as 0.9 because it is not counting the zero at the end. I would like it to bring in .90 Is there a way I can fix this. Maybe change the format or something. Please advise

Thank you in advance,
Payal

 

[boblarson]

You have to use the TEXT datatype to have it store trailing zeroes.

 

[vbaInet]

Would something like this not suffice (for display purposes only):

iif(len(right(0.9 & "", instr(1,0.9 & "", ".") - 1)) = 1, 0.9 & "0", 0.9)