Append Query

[supportt]

Not sure what the problem is, I have a access db I have been working on for a while that has a table for an auto number append query. The table has two columns, ID and PRO_HSTA, I am trying to get it to start with a particular number when creating records. It did work some time back, not sure what changed, if I delete all my sample records out of the database and run my auto append query, it does start with the correct number. But, after that it is not, seems to be using access to pick off where the last record number was. Anybody have any suggests?

Thanks

David

 

[Pat Hartman]

That's the way autonumbers work. Access just keeps incrementing. Usually when someone asks to start the autonumber at a particular place, it is a one-time event. Once the autonumber is started at the appropriate place, it just keeps on going. Kind of like the Enegizer Bunny. What are you trying to accomplish?

 

[supportt]

Autonumber

Hey Pat, well, I am trying to start a new record with a certain number, that's it.

David

 

[Pat Hartman]

I still don't understand what you are doing. Are you deleting all rows from the table and want to restart from zero? Are you trying to create gaps by skipping a bunch of numbers?

 

[supportt]

Pat, This is a new DB and I want to start at a designated number, like 2245. That is for the first record I create in the db.