i have a database that automatically assigns a random id to each entry in a feild, i was wondering how i could make it use a range to generate this number so i dont end up with ids ranging from 1-99999999999999 instead have them range from say 1000-9999, i am using access 2000 and i already set it to use auto id and random but could not figure out how to set a range, please help!<BR><BR>Ryder