Count? (Access 2000)

Topic

New Reply

OK…probably elementary to you all…

For example, imagaine a check numbering process. As a check is issued, a check number is assigned to the check. i.e. if the first check issued is 1000 then the second check issued would be 1001.

What must I do to develop a method to start at say 1000 and for each new entry increment it by 1.

Hope I made myself clear … and hope someone has an answer.

Thanks,

Reply | Quote

Replies

Given the circumstances, the best way is to use the DMax function. You lookup the highest checkNo value in your table, then you add one to it. The code below would handle this, and it uses the NZ function to start at 1000 if the check table is empty.

NewCheckNo = NZ(DMax(“checkno”,”tblChecks”),1000) + 1

Reply | Quote