Select certain characters in a text field...? 1

[TeddyvN]

I have a text field in a table where years are entered separated by comma's, e.g.: "1999, 2000, 2001".
What I would like to do is, in an update query, get the last 4 characters out of this text field and put them in a number field... From this example the numbers 2001 would end up in the number field.

Any ideas? Theo van Netten

 

[mp9]

Look up the Mid() and Right() functions in Access help - these will help you sub-string your text field, and can be used from within queries as well as in VBA.

http://www22.brinkster.com/accessory/

 

[TeddyvN]

Thanks! Exactly what I was looking for! Theo van Netten