Criteria for changing starting value of AutoNumber field

  • Thread starter Thread starter Socorro
  • Start date Start date
S

Socorro

Hi,

I'm trying to append an AutoNumber field with no records
(as yet) to commence numbering as a designated 10-digit
number (to be translated as barcode) and continue
numbering sequentially with each new record.

I've employed Access 2002 Help instructions for changing
the starting value of an Auto# field, but don't know how
to write criteria/expressions. So without criteria, the
append query says "You're about to append 0 row(s)."
Then, of course, nothing changes.

By following Acess Help instructions (except for
specifying criteria), SQL reads:

INSERT INTO Assets ([Barcode#])
SELECT Temporary.[Barcode#]
FROM Assets INNER JOIN [Temporary] ON Assets.[Barcode#]=
Temporary.[Barcode#];

the INNER JOIN was added to SQL after I created
relationship between tblAssets and tblTemporary in an
attempt to make this work. otherwise it reads:
FROM Assets, [Temporary];

I thought I could get away with Table/Query/Report Wizards
to create a simple database :) and I'm smart, but I'm
afraid I may have bitten off a little more than...

can you please help? thank you very much.
Socorro
 
Suppose that you have a table called MyTable with an autonumber field called
MyAutoNum and you want your autonumber to start at 1000, you can create a
new blank query, activate the SQL View, and type this:
Insert Into MyTable([MyAutoNum]) VALUES (1000);

Sal
www.cedrostec.com
 
Back
Top