OK. That should work. Be sure to substitute your actual table and column names. Run the delete to empty the table, run the ALTER query, then run the INSERT query.
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 12:52 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar