Expression Question

  • Thread starter Thread starter rciolkosz
  • Start date Start date
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.
 
If the alpha characters are always on the right then you can use --
Val([YourFieldName])
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autonumber queestion 3
Query based on Check Box 1
Problem with expression 7
Selecting the numeric portion of a text field 1
Complicated elements in a table 9
Access 2002 Help 1
update form on change of field used in expression 1
USING TABLE VALUE IN "BETWEEN...AND" EXPRESSION 5

Back
Top