Can I manually edit the Autonumber 1

[JamesLynch]

In my last query I asked....

I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.
With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first?
Using some sort of automated repoprt Perhaps?

Chip38,
Thank you for your suggestion, however it hasn't quite resolved my question.

Is it possible by using the Access function to get extrenal data, to add to an existing table instead of overwriting the previous one or creating a new one.

I run a customer query report on a daily basis and each day have assigneed an autonumber, i.e. 1 to 25.
The following day the Autonumber (which is ALSO my Primary Key)restarts again from "1" as I am technically creating a new table.

Can I manually edit the Autonumber for any secondary day so that Access will think that it is seeing an addition to the last set of data rather than a whole new table?

All suggestions welcome

 

[MichaelRed]

I haven't followed your previous post. Just 'guessing', you are importing records on the "daily" basis and overwritting the old, but now want to continue an AutoNumber Sequence.

First - and formost, you should generally not import directly into a 'production' table, If that operation 'fails', you can be in serious trouble. Import new information into a temp table, 'groom' it (validate whatever might be a problem), correct any discrepancies, and then 'append' the new information to your production table. It DOES require a small bit of additional work/codeing/ ... -BUT, it protects you from needing to offer the 'bad data is better than no data' excuse to your boss, which I think is a GOOD thing.

Second, by following the above, you can (if I understand what your'e attempting) you can easily get the AutoNumber to track the continuation of the sequence. To do this, all you need to do is simply delete the previous records from the 'production' table immediatly prior to appending the new records.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places