More Zip Code Issues

garygdj

Registered User.
Local time
Today, 14:41
Joined
May 25, 2006
Messages
19
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
 
Last edited:
Use the "Right" function Right([zipcode],4)
 
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
 

Users who are viewing this thread

Back
Top Bottom