Display Problem With Numeric Values

[razorking]

This seems to have me stumped:
I have a table that has numeric values for tax rates. The field type is numeric. The field size is double, format is fixed, decimal places is 3.

I have values in the table that look like this:
Local Rate
0.005
0.010
0.011
0.012
0.020

I have a need to display just the last two digits. I have tried different things but cannot get what I want. I tried the right function but, it comes out like this:
0.005=05 - correct
0.010=01 - not what I want, I want 10

They all come out the way I want, using the right function - with the exception of the ones that end with 0.

Is there not a way to simply have it dispay the last two digits?

 

[c_smithwick]

The trailing zero is not a significant digit, hence when you run the Right function on the data it is dropping the insignificant digits, converting the number to a string and displaying the last two digits stored. The only workaround I can think of for this is to store your values as text.

 

[gemma-the-husky]

are these %ages

is 0.005 = 1/2 %
and 0.01 = 1%

knowing this this will help actually

 

[pbaldy]

See if this shot-in-the-dark works:

Format((FieldName * 1000), "00")

 

[razorking]

They do represent percentages, but are now in decimal format. I think I am just dense. It looks like I just need to multiply the number by 1000 and I will get what I want.

 

[razorking]

See if this shot-in-the-dark works:

Format((FieldName * 1000), "00")

Yes, this is what I need.

Thanks!

 

[pbaldy]

No problemo!