Rabu, 25 Juni 2014

Re: [MS_AccessPros] Append table issue

 

John,

I am emptying the table each time. I will give that a shot. Thank You
 
Jim Wagner



On Wednesday, June 25, 2014 9:41 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jim-

If you're emptying the target table first, you can reset to 1 by executing an SQL command something like this:

ALTER TABLE MyTable ALTER COLUMN NameOfAutoNumberField COUNTER (1, 1);

That will reset your auto number field  to start back at 1 and increment by 1 - as long as the table is empty.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jun 25, 2014, at 11:08 AM, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello all,

I have a table that I would like to append records from another table. The issueI am encountering is this.

How do I append the records into a table. I want to start at 1 every time.

I am able to append the records to the table but the new auto number are 4 at digits. Like 5299, 5300 etc.

Thank You 

Jim Wagner



__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar