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 : 1753 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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..

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts