Question Starting value of autonumber

[Oucch]

I am trying to change the starting value by running an append query from the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209696

I have entered 999 in field i wish to append, but when i run the query it says "you are about to append 0 rows".

Help please.

 

[Oucch]

Don't worry now solved.

 

[MSAccessRookie]

Don't worry now solved.

Great that you found your own resolution to the problem, but for the benefit of other people who might encounter a similar problem in the future, would it be possible for you to provide some details regarding your resolution?

 

[Oucch]

Great that you found your own resolution to the problem, but for the benefit of other people who might encounter a similar problem in the future, would it be possible for you to provide some details regarding your resolution?

For the append query I had opened both tables, when actually all I needed was the temporary one. Pretty simple, but makes a big differece.