Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    removing ones and tens digit (Access 2003)

    Is there a way to remove the last 2 digits from whole numbers to have total 10-digits. For example: sample numbers are 000000381100, 001094362000, 001094943900, 001096877500, 001777475700, 000156459400. But would like result to show: 0000003811, 0010943620, 0010949439, 0010968775, 0017774757, 0001564594 (with last two zero removed).

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: removing ones and tens digit (Access 2003)

    Is this a text field that contains numeric values? If so:
    - Create a backup of the database first, or test on a copy of the table.
    - Create a query based on the table.
    - Add the relevant field to the query grid.
    - Select Query | Update Query.
    - If all entries are 12 digits, enter the following in the Update to line (where FieldName is the name of the field):

    Left([FieldName],10)

    - If the entries can have different length, use

    Left([FieldName],Len([FieldName])-2)

Posting Permissions

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