Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Connecticut USA

    Deleting Spaces

    My database has duplicates because when I loaded the excel spreadsheet using get external data some phone numbers were (111)111-1111, and some were (111) 111-1111 so that nasty space after the right parenthesis causes my querry not to see a duplicate. There are 88,000 records in my database. Is there any way I can remove the space?

    thank you


  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Use an Update query, where the field (say it called "Phone") is updated to Trim([Phone]).
    John F

  3. #3
    Join Date
    Dec 2005
    Wilmington, DE - USA

    Try this:

    UPDATE YourTable
    SET PhoneNumber = Replace([PhoneNumber], " ", "")

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

Similar Threads

  1. Problem Deleting Records with ADO
    By bdicasa in forum Programming
    Replies: 0
    Last Post: 08-21-2008, 09:27 AM
  2. Deleting Record Contents, not complete record...
    By Charles Waters in forum Access
    Replies: 2
    Last Post: 06-24-2008, 12:00 PM
  3. Replies: 2
    Last Post: 01-14-2008, 12:15 PM
  4. Delete query, deleting customers froma table.
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-14-2006, 11:33 AM
  5. Replies: 0
    Last Post: 11-28-2005, 01:04 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