General discussion

Locked

Access 2000 - Autonumber query

By Adisha ·
Is it possible to start an autonumber at a specified value other that 0?

I have tried to modify it but with no success.

Many thanks for your help in advance.

IT Guru

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 - Autonumber query

by Peyison In reply to Access 2000 - Autonumber ...

It is not possible, but you can work around it. Enter n-1 records in to the table, where n is the number you want the autonumber field to start at, then delete the records.

Hope this helps.

Collapse -

Access 2000 - Autonumber query

by Adisha In reply to Access 2000 - Autonumber ...

Many thanks - your help worked a treat!

Collapse -

Access 2000 - Autonumber query

by Adisha In reply to Access 2000 - Autonumber ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums