gacto
asked on
Microsoft Access Autonumber
I am setting up a db with Autonumber as the primary key in several tables. I am creating the autonumber through a form entry and I am having problems with the formatting. I need the autonumber to be 5 digits and always positive. I set my field property in my table to the following:
Field Size: Long Integer
New Values: Random
Format: 00000
When I created the first two records in this table through my form the first autonumber that was 1248127065 and the second was -7090466874. Two problems that I need to fix:
1. Autonumber number needs to be 5 numbers.
2. Autonumber should never be negative.
I am working in Access 2007.
Field Size: Long Integer
New Values: Random
Format: 00000
When I created the first two records in this table through my form the first autonumber that was 1248127065 and the second was -7090466874. Two problems that I need to fix:
1. Autonumber number needs to be 5 numbers.
2. Autonumber should never be negative.
I am working in Access 2007.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.