Microsoft Access

[Rolando São Marcos]

In the table SOCIO(IDSocio,Nome,Numero,...), the attribute IDSocio is an
Automatic Number.
How can I do the same for attribute Numero, make this attribute automatic
when i insert new values in the table?
Thanks.

 

[Jeff Boyce]

Rolando

Access only permits one "Autonumber" field per table. If you wish to use
other fields for numbering/sequencing, you'll need to create your own. Try
mvps.org/access and/or Google.com, and look for "custom autonumber" (they
are not true 'autonumbers', but this is how they have been described).

Good luck

Jeff Boyce
<Access MVP>

 

[KARL DEWEY]

You can set the default value of a number field to a calculated value.

An example would be a query to return the maximum number in field +1.