ID field

B

Bhavini Patel

How can you design the database so that the ID field is
set to a number which is not 0 (the default)?
 
C

chas

Hi Bhavini,

Open the table in design view, select the ID field and
change the Default Value property to whatever you want it
to be. Of course, if it is a unique indexed field you
will not be able to add more than one record with the same
value.....

hth

chas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Making id cards 1
Auto populate value from one task to another in MS PROJECT 0
Create field default using the ID field in Access 2007 0
VBA works in orignal but fails in copy of database 1
Creating task with Given ID 0
Making a macro only work on certain files 2

Top