Auto Number set

  • Thread starter saman110 via AccessMonster.com
  • Start date
S

saman110 via AccessMonster.com

Hi,

Why when I delete a record and want to create a new record Auto number does
not start from last number?

any help.
thx.
 
J

Jeff Boyce

Microsoft Access' Autonumber data type is designed to provide a unique row
identifier. Nothing more.

Autonumber is generally unfit for human consumption. If you care about the
value of the number, don't use Autonumber!

What are you trying to use the number for? There may be other approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

saman110 via AccessMonster.com

I import data into my database records contains one order and I want to know
how many orders have I done so far.

thx.
 
J

Jeff Boyce

Create a query against the table.

Click on the Totals query button.

Select any field that would have data in all records.

Change the "GroupBy" to "Count".

You get a count of the number of records.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

saman110 via AccessMonster.com

thank you for your response.

I did that and in every record I got 1 instead of 1 2 3 4 5,....

Jeff said:
Create a query against the table.

Click on the Totals query button.

Select any field that would have data in all records.

Change the "GroupBy" to "Count".

You get a count of the number of records.

Regards

Jeff Boyce
Microsoft Office/Access MVP
I import data into my database records contains one order and I want to
know
Click to expand...
[quoted text clipped - 10 lines]
Click to expand...
 
J

Jeff Boyce

I don't understand.

"1 2 3 4 5..." sounds like numbering each record. I thought you wanted a
count of the number of records?

Please post the SQL statement of the query. Open the query in design view,
click on the view button's dropdown, select SQL, copy/paste the SQL
statement.

Regards

Jeff Boyce
Microsoft Office/Access MVP

saman110 via AccessMonster.com said:
thank you for your response.

I did that and in every record I got 1 instead of 1 2 3 4 5,....

Jeff said:
Create a query against the table.

Click on the Totals query button.

Select any field that would have data in all records.

Change the "GroupBy" to "Count".

You get a count of the number of records.

Regards

Jeff Boyce
Microsoft Office/Access MVP
I import data into my database records contains one order and I want to
know
Click to expand...
[quoted text clipped - 10 lines]
any help.
thx.
Click to expand...
Click to expand...
Click to expand...
 
Top