Good Afternoon,

I have a free table used to store Daily Transactions until the Day's activity is finalized when they are appended to a Table which stores the history.

I have an autoincrementing integer field on this Transaction table that I would like to reset to 0 when the day is finalized and the table is zapped.

Is there a way to do this short on dropping the column and readding it.

Any assistance would be greatly appreciated.

Michael Brennan-White