Reset Autonumber after export 2

[valgore]

So i have three tables.

RawImport- where i import raw data
AmexCurrent- where certain columns of RawImport go for editing
AmexHistorical- where AmexCurrent data goes for archiving once its complete

What i want to do is when data comes into RawImport and i move the data into AmexCurrent, i want the ID# to start back to one so that the next time i import, the data in RawImport will start at one.
i want to do the same for AmexCurrent

Valgore

 

[PHV]

A starting point:

DoCmd.RunSQL "ALTER TABLE RawImport ALTER COLUMN [ID#] COUNTER(1,1)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[valgore]

Wow. that was amazing. thank you SO much.

Valgore