More Zip Code Issues

[garygdj]

I have a Zip Code field that contains the Zip Code and the Zip Code Suffix all together. No spaces or dashes between them. I want to seperate the Suffix the last 4 characters of the zip code into a new field. I'm not sure how to get access to look at only the last 4 characters.

Thanks for your help.

Gary

 

[namliam]

Use the "Right" function Right([zipcode],4)

 

[RCurtin]

By the way you can use the Right function in a query:
- just create a query that includes the Zip code field
- create an expression to show the results of the expression