Function

tennisbuck

New member
Local time
Today, 04:32
Joined
Aug 14, 2013
Messages
3
Which function in access return the the last value in a string.

Period 1 Period 2 Period 3
10 20 30

I need the function to return 30.

The reason behind this I have different periods for categories and my formula I'm using needs the ending value.
 
Last edited:
IF you know that the data you require will be the last 2 digits, then perhaps you could use the Right() function to return the required value. Something like:
Right([YourField],2)
However, IMHO, I would suggest that you change your table structure, so that each field in a table stores one piece of data. I believe this is known as "Normalization". I'm sure that a search in any Access forum or in google will return you all you would need to know.
 

Users who are viewing this thread

Back
Top Bottom