Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Need help on MS Access.


  • Please log in to reply

#1
MaMister

MaMister

    Member

  • Member
  • PipPip
  • 96 posts
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?

Edited by MaMister, 25 September 2006 - 04:07 AM.

  • 0

Advertisements


#2
Jrenter2

Jrenter2

    Member

  • Member
  • PipPipPip
  • 435 posts
Hi MaMister,

Have you tried to Format the Member number to "00000"?
  • 0

#3
MaMister

MaMister

    Member

  • Topic Starter
  • Member
  • PipPip
  • 96 posts
Hi, the method works but when I export to dbf file (for marketing purpose), it become 01234.0000

Then I tried export to a ASCII file and it remains as 01234.

I found the solution! It is by using update query : 0&[FIELDNAME]

Hope this can help out some others in the future...

Edited by MaMister, 26 September 2006 - 06:41 AM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP