Hey guys,
I got a big problem. I'm trying to remove some contents included in each field. How can I do this globally?
Thanks a lot.
Hey guys,
I got a big problem. I'm trying to remove some contents included in each field. How can I do this globally?
Thanks a lot.
What sort of "contents" are you trying to strip out of your fields? Can you give us a little more detail? Also, please do not post your issue more than once. I've deleted the one in Forms forum.
I have one column for the address, which is composed of both street name and zip code. I want to remove all the zip codes from that column. How can I do that?
Btw, sorry for the double posting. I didn't realize that I posted my thread in a wrong column until I did that.
Do you want to put the Zip code in another field? Can you post a sample of one of the address fields data so we can see it?
Here is the sample:
SNOWDEN AVE at WENTWORTH ST, 91402
I dont want to include the zip code in anywhere else.
Thanks.
So the field is *always* appended to the end after a comma? If so then
Left([YourFieldName],Len([YourFieldName]) - 6) should return the value for which you are looking.
Where should I put this criteria? Is that query? But which one?
Thx
You could permanently alter the field with that function or simply use it in a query when you need it.