<div>
You cannot format an Autonumber field. You can create sequential numbers for each year, but you cannot do this at the table level. You must do it through your forms.<br />
<br />
Do you have multiple users in this database? If you do, the task is much more involved.
</div>


You cannot format an Autonumber field. You can create sequential numbers for each year, but you cannot do this at the table level. You must do it through your forms.

Do you have multiple users in this database? If you do, the task is much more involved.

<div>
Hi LSMConsulting,<br />
<br />
Can you show how I can create a custom sequential number that can be used as primary key? Yes I do have multiple users in this database.<br />
<br />
Thanks<br />

</div>


Hi LSMConsulting,

Can you show how I can create a custom sequential number that can be used as primary key? Yes I do have multiple users in this database.

Thanks


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm having a table that has a primary field as auto number. I want to add year to this field and have it reset after each year. Can anybody help me with this please? <br />
&nbsp;<br />
Currently it's format as 0&quot;8-&quot;000 but I want it to be using a datetime field called DateofService and use the year mentioned there and create/append the autonumber<br />
<br />
For example: DateOfService: 05/01/2007 then GC # 07-001 and if there are other records for that year it should increment it sequentially. If the year changes it should reset and start with the same (05/01/2008 08-001).<br />
<br />
Thanks<br />
<br />

<pre><code id="code-359932">Table name: TBL_BCInformation
Fields: GC # (primary key) autonumber
           DateofService Datetime
</code></pre>
</div>
</div>


Hi Experts,

I'm having a table that has a primary field as auto number. I want to add year to this field and have it reset after each year. Can anybody help me with this please? 
 
Currently it's format as 0"8-"000 but I want it to be using a datetime field called DateofService and use the year mentioned there and create/append the autonumber

For example: DateOfService: 05/01/2007 then GC # 07-001 and if there are other records for that year it should increment it sequentially. If the year changes it should reset and start with the same (05/01/2008 08-001).

Thanks


Autonumber Format

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.