I had created a database programe using vb6 and ms-access, I want to give a serial no. on my report output e.g.
4. Billy etc....
and if no. 2 is deleted from the database and when printing a report again the serial no. should go down automatically instead of missing no. 2.
Anybody knows how can I do this, suggestion is warmly welcome please.