reset record number

[aftershokk]

I have a cumlative DB that exports a file daily based on what was keyed daily..

Therfore, every day I am sending only new records from the DB to a vendor.

I was using autonumber to assign the record number but they now want the record number to restart at 1 for a new days worth of data entry.

So today's file may have record number 1-10 (10 recs) and tomorrow's file would have 11-20 populated om the record number field.

My new record number would have to be 1-10 today and 1-10 tomorrow etc..

Not sure how to do this easily.

thanks!!!

 

[RuralGuy]

The AutoNumber is not designed to be used the way you are using it and could be unreliable under certain conditions. See if Stephan Lebans can help in this situation.

 

[aftershokk]

response

I am going to keep the autonumber field and create a new field for this purpose.
Just not sure how to handle.

 

[RuralGuy]

Did the other link I supplied help at all? Here's another option.
Set AutoNumbers to start from ...

 

[aftershokk]

I don't know how to write code

Can I delete the records and compact within DB using a macro?

 

[RuralGuy]

You can set up your system to Compact on Close!

 

[RuralGuy]

Here's a thread you might find useful.
http://www.access-programmers.co.uk/forums/showthread.php?t=121476&highlight=TDC%7D