I want to update series number(not the primary key into a temporary table using Ms-access query.

Posted by Rrana under VB.NET on 1/4/2013 | Points: 10 | Views : 747 | Status : [Member] | Replies : 1
Hi All,

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.

Ex:--

Table

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

Like this

Thanks in advance

Sucharitha Goud
Bank Of America..



Responses

Posted by: .Netlearner on: 1/7/2013 [Member] Starter | Points: 25

Up
0
Down
Hello Sucharitha,

You can create S.No Field.Before Inserting a row check the row count of that table if grater than zero select the Previously inserted S.No value and just increment it.If number of rows i zero start with 1/thenumber you want.


Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response