k_adli
asked on
How do i create running serial number in Reports
Hi,
I have database with all the company's employees particulars and details inside.
When printing reports, i would like a 'Serial No.' column for each employee which runs consecutively from one employee to another. This serial no. need not be in the 'table' because i only need it to appear in my report.
I tried using the 'Auto-Number' function but the serial no. column does not run consecutively if i delete one of the employees record. It would go like ...
1.
2.
3.
5.
6.
In this case, the serial no. '4.' is deleted as the employee that had the serial no. '4' assigned to it using the auto-number function has been removed from the database. Really hope u all could help me in this.
Thank You.
I have database with all the company's employees particulars and details inside.
When printing reports, i would like a 'Serial No.' column for each employee which runs consecutively from one employee to another. This serial no. need not be in the 'table' because i only need it to appear in my report.
I tried using the 'Auto-Number' function but the serial no. column does not run consecutively if i delete one of the employees record. It would go like ...
1.
2.
3.
5.
6.
In this case, the serial no. '4.' is deleted as the employee that had the serial no. '4' assigned to it using the auto-number function has been removed from the database. Really hope u all could help me in this.
Thank You.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Took me a a lot of time to find out this was the easy way <LOL>.
Success with the application !
Nic;o)
Success with the application !
Nic;o)
ASKER