Parse out data in a field... 1

[AlexCpd]

I have an Access 2003 DB with a field that contains employee info. I need to parse out the employee number. The field data looks like this -

"Doe John 12345"

There are no commas only spaces. The employee numbers are all 5 digits in length at the end of each record.

I am rather new to this so bear with me. I would appreciate any "Step by Step" help that can be provided!

thanks,

Alex

 

[akirk]

you could build an expression using the Right Function. In your case it would be something like:

right(yourfieldname,5)

place this in the field name in your query.

hope this helps

 

[AlexCpd]

Thank you very much for the prompt response...That worked perfect!

Alex