CARG Formula

[tennisbuck]

Hi,

Which function in access return the first number in a string and the last value in a string.

Period 1 Period 2 Period 3
10 20 30

I need the function to return 10 and 30.

[Bob Fitz]

Please see my post #2 at: http://www.access-programmers.co.uk/...39#post1285139

[tennisbuck]

Thanks for the help!