Wont Truly Delete Records Out

[TINA BEARD]

I Am Trying To Make A Data Base That Clones To Our Previous Year, And The Problem That I Am Having Is That I Have Our Work Order Field Set To An Auto # And Then When I Was Testing It To See If It Would Work I Put In A Few Test Records And It Was Working Fine So Then I Selected To Delete All Records So That The Real Ones Could Be Put In- So When We Started That, The First Record Is 11801 Which Is Cool But When You Go To Record # 2 That # Is 11805 ( Because I Ran I Few Test Records To Make Sure That It Works. I Need To Know How To Reset The #'s So That I Can Get Those Records Back. Please Help I Am Going To Throw My Computer Real Soon Through The Wall.

 

[Ukraine82]

I'm not sure I understand, but it seems to me that you want to refresh you autonumber after you deleted couple examples. If so, once you delete you sample records you can compact and repair the database. This will refresh your autonumber.

hth,
Michael

 

[TINA BEARD]

Thank You Very Much Michael, That Is What Exactly Needed To Be Done.

 

[Ukraine82]

No problem - Glad I can help

Michael