> Is there away to reset an auto incrementing field count? I have a
> database that currently has 935 records in it but because I have
> deleted a few the current number used for NEW records is 938 How
> can I get it to count the records and assign a record number based on
> the total count?
>
> Hope that makes sense! Thanks for looking!
>
> --

> Jason Pruim
> Raoset Inc.
> Technology Manager
> MQC Specialist
> 3251 132nd ave
> Holland, MI, 49424
> www.raoset.com
> japruim@raoset.com

AFAIK, you need to drop and then recreate the auto-increment field,
otherwise you'll get holes when you delete a record.

David