Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    New Salem, North Dakota, USA
    Thanked 0 Times in 0 Posts

    keeping zeros as first digit (2000)

    We have some ID numbers that have zero as the first digit. They are fine in the table but the queries do not seem to like them. How do I keep them from disappearing in the query...I need the query to compare the first 2 numbers of the employee ID and the last 2 numbers of the company ID.
    Thanks in advance for you help,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: keeping zeros as first digit (2000)

    If the ID field is a number field, leading zeros are a matter of display format only, they are not stored in the field itself. You could use an expression such as Left(Format([ID],"00000"),2) to retrieve the first two digits of the formatted number (in this example, the length is 5, change to suit your situation.)

Posting Permissions

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