Expression Question

R

rciolkosz

I have a field in my table that displays numbers with two letters at the end
on some of the records. example 56789rc

What is the expression to only carry over the numeric portion of that field
into the new field.
 
K

KARL DEWEY

If the alpha characters are always on the right then you can use --
Val([YourFieldName])
 
F

fredg

I have a field in my table that displays numbers with two letters at the end
on some of the records. example 56789rc

What is the expression to only carry over the numeric portion of that field
into the new field.
Click to expand...

=Val([FieldName])

You can use the above expression in an unbound text control on a form
or a report to display just the number, however it is not good
database design to store both that derived number and the original
text in a table.
 
Top