WHAT EXPRESSION DO YOU TYPE IN A TEXT BOX TO NUMBER RECORDS SEQUENTIALLY IN ACCESS?

1 answer

Answer

1208065

2026-05-13 07:00

+ Follow

In Microsoft Access, to number records sequentially in a text box, you can use the expression =Nz(DCount("*", "YourTableName", "YourCriteria") + 1, 1). Replace "YourTableName" with the name of your table and "YourCriteria" with any criteria you want to apply. This counts the number of records that meet the criteria and adds 1 to generate the sequential number.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.