User Profile

Collapse

Profile Sidebar

Collapse
Ivan Popov
Ivan Popov
Last Activity: Dec 5 '10, 10:52 PM
Joined: Nov 28 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ivan Popov
    replied to generate a unique serial number
    in Access
    All numbers must be consistent.
    See more | Go to post

      Leave a comment:

    • Ivan Popov
      replied to generate a unique serial number
      in Access
      To NeoPa:
      Serial number should be unique per record.
      The number part need to be a value one more than the last value used.
      For example, the first one "AA000001", second "AA000002" .... then "AA999999". .... then "AB000001"..... .
      See more | Go to post

        Leave a comment:

      • Ivan Popov
        replied to generate a unique serial number
        in Access
        Thanks Stephen! There is table with information about cars and its owners and some other documents, all this information will be writen on the special list (one row for one car and its owner), I need a unique serial number for each row in the table. Two letters and 6 numbers is a standart for this documents. Valid is a separate generator for letters and numbers, in diferent fields. I hope someone will help me ;)
        See more | Go to post

          Leave a comment:

        • Ivan Popov
          started a topic generate a unique serial number
          in Access

          generate a unique serial number

          I need to generate a unique serial number for each field in the table. The serial number shall consist of two letters and six numbers, for example AA123456. Someone can suggest how to do it in MS Access
          See more | Go to post
          No activity results to display
          Show More
          Working...