Results 1 to 8 of 8
  1. #1
    nancyszn is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    4

    Angry Remove contents from each field

    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.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    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.

  3. #3
    nancyszn is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    4
    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.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    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?

  5. #5
    nancyszn is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    4
    Here is the sample:
    SNOWDEN AVE at WENTWORTH ST, 91402
    I dont want to include the zip code in anywhere else.
    Thanks.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    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.

  7. #7
    nancyszn is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    4
    Where should I put this criteria? Is that query? But which one?
    Thx

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You could permanently alter the field with that function or simply use it in a query when you need it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Updating one table with anothers contents
    By munkifisht in forum Access
    Replies: 0
    Last Post: 07-22-2009, 03:22 PM
  2. remove record count
    By theITguy in forum Access
    Replies: 1
    Last Post: 03-06-2009, 06:22 PM
  3. Remove Quotes within Data Values
    By kfschaefer in forum Programming
    Replies: 0
    Last Post: 02-26-2009, 01:15 PM
  4. Fields and their contents
    By Ham in forum Access
    Replies: 0
    Last Post: 02-06-2009, 07:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums