How to leave out the last character of a value in a report 3

[cheapo]

Hi,

I need help to solve my report problem.
I have a form called "Apple" and it has a value called "Tree" that is linked to a column in a table.

The value of tree is a bunch of numbers that ends with a letter.
e.g.
1s
12s
123s
1234s
and many others.

Now my Q is that how do make it such that when I print out the report only the numbers are displayed(which means that the last character is left out).

Hopefully someone can help me.

Best Regard,
Ronny.

 

[scriverb]

Use the following in the ControlSource:

=Left([Tree],Len([Tree])-1)

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[cheapo]

Thanks Bob,

but ..... my fault... I forgot 1 thing.
I also want the report to show everything if [Tree] is all numbers.

e.g
123 becomes 123
123s becomes 123

Thanks!

 

[Molby]

In that case use

=Val(Tree)

 

[scriverb]

Good update there Molby. That will do the trick for Cheapo.

Star on me!!

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[Molby]

Thanks Bob, didn't mean to steal your thunder!

 

[scriverb]

Not a problem. As in most systems specifications received from the end user the requirements have changed. This is an expected milestone in development which we all have to deal with.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[cheapo]

Thanks to both of you guys for the help!

 

[scriverb]

Thanks Cheapo. My comments above were not of a derogatory nature. I hope you didn't take them that way. After years of development I expect the specs to change and it is my job to draw out of the User of the system all the needed info to do the right kind of job. Just a clarification of my meaning.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]