Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Is there a function to do this....

    Hi,

    Is there a function to do the following....

    I have a table with approx. 900,000 records.
    One of the columns(text) has values such as.....

    4589
    3211
    12
    999345

    877

    I would like to fill the column with 9 bytes preceeded with zeros...
    so the above examples will output as:

    000004589
    000003211


    000000012
    000999345
    000000000
    000000877

    Hope this makes sense....thanks in advance

  2. #2
    Join Date
    Dec 2008
    Posts
    2
    The easiest way is ake your table and copy it to excel the format the column with the custom feature fill the custom feature in with 9 zeros and then all the entries will have preceeding zeros, Then import the list back to access with the new item numbers

  3. #3
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear Nowherefast,

    The easiest way to do that in the following steps:
    open table design view
    select the mentioned field
    in field properties write in format 000000000
    save the table and open it.

    Kindly try and feedback.

    Ahmed

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

Similar Threads

  1. Creating INT function within a Query
    By LCorrieri in forum Queries
    Replies: 3
    Last Post: 01-25-2008, 10:38 AM
  2. Calling a function and returning a value
    By 3dmgirl in forum Programming
    Replies: 0
    Last Post: 04-23-2007, 02:20 PM
  3. SELECT FUNCTION help please
    By scott munkirs in forum Queries
    Replies: 0
    Last Post: 10-17-2006, 07:44 AM
  4. transferspreadsheet function
    By jeffj in forum Import/Export Data
    Replies: 3
    Last Post: 03-13-2006, 11:59 AM
  5. Need Help for Dlookup function
    By wasim_sono in forum Programming
    Replies: 5
    Last Post: 01-04-2006, 08:18 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