Auto Number set

[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.

 

[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

 

[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.

 

[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

 

[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,....

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

[quoted text clipped - 10 lines]

 

[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

thank you for your response.

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

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

[quoted text clipped - 10 lines]

any help.
thx.