Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Question COPY DATA and TRIM

    I have a large data table ( 400,000 records ). All records have a element which I would like to copy to a new field on the existing records and the trim from that field n number of characters. I have created the new field in the record already.



    Any ideas

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    You can use right, lift or mid function according to the location of the element you need.

    Ahmed

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

Similar Threads

  1. Copy or Back-up of DB Switchboard not working??
    By techexpressinc in forum Import/Export Data
    Replies: 1
    Last Post: 12-30-2008, 11:49 AM
  2. How to move copy queries and reports.
    By Fred C in forum Access
    Replies: 1
    Last Post: 11-08-2008, 10:24 AM
  3. Replies: 0
    Last Post: 09-21-2008, 11:28 AM
  4. Trim
    By JMantei in forum Forms
    Replies: 1
    Last Post: 06-20-2006, 02:06 PM
  5. Copy a record
    By RHall in forum Programming
    Replies: 2
    Last Post: 02-23-2006, 07:40 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