I want to update series number(not the primary key into a temporary table using Ms-access query.
Every time i deleted the record from that table and insert new rows.
Collapse | Copy CodeEmpName Desig Loc
AA Officer Hyd
Bb Mgr Ind
CC Assoc Us
DD Sr.Mgr UK
I want the table with series number
Collapse | Copy CodeS.No EmpName Desig Loc
1 AA Officer Hyd
2 Bb Mgr Ind
3 CC Assoc Us
4 DD Sr.Mgr UK
Thanks in advance