Modules

  • Thread starter Salvio F. Arguelles
  • Start date
S

Salvio F. Arguelles

I need a function that could automatically add numbers in
the table by 1 with a resetting function
 
N

Naresh Nichani MVP

Hi:

Try using the DLookup function

dlookup("Max([ID])+1","[tbl1]","")

This assumes you want to get the max of the [ID] field of table [tbl1] and
add 1 to it in a function.

Regards,

Naresh Nichani
Microsoft Access MVP
 

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

Excel - Wich Function should I use? 1
VBA - (re-) Set a Table Style 2
Setting a default zoom in Infopath 0
Making a macro only work on certain files 2
Dcount -Date Criteria - Won´t find it - 0
Proposal template with removable sections 0
Page numbering with Merged Document and IF statements 1
Determine if previous "character" is a section break 3

Top