Access_Headaches
Registered User.
- Local time
- Today, 09:44
- Joined
- Jun 17, 2010
- Messages
- 28
We have a mailing list with 83,000 names in it. Our problem is we need to send it to our printers without Full zip codes "55555-5555".
I ran a query to find the incorrect format entries. "*****-****" and came back with 43,256.
Now I need to do an update query to change them to a five digit zip code. Can someone let me know how to do this?
I tried
Update to "*****"
Criteria "*****-****"
That did not work. Any help would be fantastic! Thanks.
I ran a query to find the incorrect format entries. "*****-****" and came back with 43,256.
Now I need to do an update query to change them to a five digit zip code. Can someone let me know how to do this?
I tried
Update to "*****"
Criteria "*****-****"
That did not work. Any help would be fantastic! Thanks.