Auto list

[duvenhlc]

Please help

I need to list tasks in a sequential numbers. Meaning that the task numbers must follow one another (not the Autonumber PK). I can do this with Dmax nz function. I need the system to be able to auto update these numbers if record is added or deleted. It is not necessarry to store these numbers, since it can hopefully be recalled in a query.

 

[HiTechCoach]

It is possible to sequential number records.

See:

How to Print a Line Number for Each Record or Group on Report


Row number
a database containing functions for the automatic row numbering of Forms, SubForms and Queries.

Hope this is what you wanted ...

 

[duvenhlc]

Thanks, I think I got it now.

 

[HiTechCoach]

You're welcome!

Glad we could assist.