<div>
you just use ..<br />
nz(dmax(&quot;ID&quot;, &quot;tablename&quot;),0)
</div>


you just use ..
nz(dmax("ID", "tablename"),0)

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I want to get the next id (primary key, autonumber) of table without using max(id). beacuse max(id) wont give the next id if the table contains no rows. i think some system table stores the next sequence of all auto number fields of tables. (in sqlite there is sequence table which holds the next id of all primary key(autoicrement) fileds). Any one know how to get the next id from system table in MS Access(2003, 2007).<br />
<br />
Thanks
</div>
</div>


Hi guys,

I want to get the next id (primary key, autonumber) of table without using max(id). beacuse max(id) wont give the next id if the table contains no rows. i think some system table stores the next sequence of all auto number fields of tables. (in sqlite there is sequence table which holds the next id of all primary key(autoicrement) fileds). Any one know how to get the next id from system table in MS Access(2003, 2007).

Thanks

Get next Id from a table in MS Access

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.