Help with Decimal.

[Floyd Forbes]

Is there way to to show the decimal places only. For example I have 43.78,
but I only want
78 to show in the field. Is there a way to do this?

Thanks

 

[bhicks11 via AccessMonster.com]

How about parsing it out with (replace mvar with your field or control name):

Set the value of the control or query column as: mid(mvar,instr(mvar,".")+1,
2)

This is assuming there are two decimal places.

Bonnie
http://www.dataplus-svc.com

 

[John W. Vinson]

Is there way to to show the decimal places only. For example I have 43.78,
but I only want
78 to show in the field. Is there a way to do this?

Thanks

What's the context? What's the datatype of the field? Where do you want to
show it? How many decimals - might you have 43 (displayed as blank, 0, or 00)?
how about 43.1215418122 (displayed as 1215418122)?

More info please!

 

[Floyd Forbes]

The datatype field is number and I only want to show Two decimals places 12.

 

[Paul W Smith]

Try

mvar - int(mvar)

 

[raskew via AccessMonster.com]

How about:

x = 12.5437
? format(100*(x-int(x)), "##")
54

Bob