Right String

[BRANDON99]

Hi

I have a fiels in a table that has the result of a calculation. The nuber could be eg. 7.85. Is there a way to extract just the decimal part of this fiels ie .85 ?

Many thanks

Brandon

 

[RoyVidar]

Where are you performing this?

Performed in an event procedure on form controls, it could look something like this:

[tt]me!txtResult.value=me!txtCalc.value-int(me!txtCalc.value)[/tt]

Roy-Vidar

 

[BRANDON99]

Hi Roy

The data is in a table, not on a form

Thanks

Brandon

 

[pcgram]

Decide wether u want to change your data into the decimal part. I.e. change the number 7.85 into 0.85 or do u want to view it as 0.85. In the first case u would make an update-query, updating Number to Number - int(numer). In the later case, u would make a select query DecNumber: Number - int(Number)

 

[BRANDON99]

Thanks pcgram, does exactly as I wanted

 

[lespaul]

I have a fiels (sic) in a table that has the result of a calculation

Do you realize that storing a calculated field breaks normalization rules?


Leslie