Results 1 to 2 of 2

Thread: Need help on MS Acess.

  1. 09-25-2006, 06:15 AM #1
    MaMister
    MaMister is offline
    Member
    Join Date
    Nov 2000
    Posts
    228

    Need help on MS Acess.

    I have created a database using access and now our company decided to add a extra 0 infront of the existing member number

    eg. the old number is 1234 now is 01234.

    How can I change for the existing few hundreds records?
    Life is what happens when you are busy planning other things
    Reply With Quote Reply With Quote
  2. 10-16-2006, 04:03 PM #2
    michaelccc
    michaelccc is offline
    Junior Member
    Join Date
    Oct 2006
    Location
    Newport, NC
    Posts
    25

    Try an update query

    In a new query, go to the Query menu and select Update Query. With just the field you want to change, go to the Update To line and put: "0"+[fieldname]

    Just change the text fieldname to the name of your field, leave the brackets.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules