Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Zero Problem (Access 2000)

    I want to append 7 zeros to the figure but i cant.If i have not zeros then it is OK, but if i have to append zeros then nothing happens.How can i avoid this problem ? In my case, according to the attachement, only the appending from the first office , number 1 does not work. in the the other offices, where there is no 0 as the fist figure, it is ok.How can i append the zeros for the office 1 ?
    i will be much obliged for your suggestions
    Attached Files Attached Files

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

    Re: Zero Problem (Access 2000)

    PaymentID is a number field. Adding 0 to a number doesn't change the number: 3+0 = 3, 753+0 = 753 and 2140395+0 = 2140395.
    If you want to show the PaymentID with 7 digits, including leading zeros if necessary, set the Format property of this field to 0000000. This will *not* change the value stored in the table, but it will change the way the value is displayed.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zero Problem (Access 2000)

    it is wonderful.I can now add the zeroes. Thank you Hans !

Posting Permissions

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