Oh happy day! hehe. I finally found out how to do an autonumber field in an Access DB using an SQL CREATE statement. You set the attribute of the field to:<BR><BR>identity(intSeed, intIncrement)<BR><BR>Where intSeed is what number to start at. and intIncrement is how much to increase the number by for each record.