Parse the last two character

[johndoe12345]

Hi,

I am new with access. I need help to parse out last two characters from the right.

Sample Data as follow:

Toronto ON <-- 1 field
Manitoba AB <--- 1 field
VAncouver BC <--- 1 field

I need to make it two fields

Thanks....

John

 

[SgtJarrow]

If all you fields are as such above:

Left([field], Len([field]) - 3) will provide the city
Right([field], 2) will provide the two digit postal code



****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[johndoe12345]

I apreaciate your help !!
Thank you