Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
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