AUTO NUMBER

  • Thread starter Thread starter =?iso-8859-1?Q?Utopic=AE?=
  • Start date Start date
?

=?iso-8859-1?Q?Utopic=AE?=

Hi

How I can do an "Auto Incremental" field (like Auto Number) but that begins at 100???

Sorry for my english

Hugs from Argentina,

Utopic.-
 
Use this expression as the "incrementing" method for a regular, numeric,
long integer formatted field:

NewNumber = Nz(DMax("FieldName", "TableName"), 99) + 1



Or you can use an autonumber field that you "preset" to 100 by running an
append query that writes a record into the blank table with the autonumber
field set to 99, then delete that record and don't compact the database
until you've added a real record:

INSERT INTO TableName (AutoNumberFieldName)
SELECT 99;


--
Ken Snell
<MS ACCESS MVP>

Hi

How I can do an "Auto Incremental" field (like Auto Number) but that begins
at 100???

Sorry for my english

Hugs from Argentina,

Utopic.-
 
Sorry for my ignorance, but, where can I put this expression*??? .... In
which part? in a Table? In a Field?

I hope you understand me.

Thank you!!!


----------------------------------------------------------------------------
----


----- Original Message -----
From: "Ken Snell" <[email protected]>
Newsgroups: microsoft.public.access
Sent: Friday, February 06, 2004 1:11 AM
Subject: Re: AUTO NUMBER
 
This expression would be used in a form that is being used for data entry.
You would run it as a VBA code step or as a macro when you start a new
record.

Based on your reply, perhaps it would be good if you give us more
description/info about what you're wanting to do so that we can provide more
specific suggestions.
 
Back
Top