Title:        ,         
Web-Link: http://www.arabteam2000-forum.com/index.php?showtopic=119793
Description: SelfNumbering
Department: Microsoft Access forum
Develop Using: Microsoft Access 2003
Assistant Tool(s): 
Version: 1.00
Last update: 01 March 2007
Date: 01 March 2007
Author: Eng. Usama El-Mokadem: musama@hotmail.com

Topic(119793) [Mar 01 2007, 01:45 PM]: By  : http://www.arabteam2000-forum.com/index.php?showuser=96695
=======
-----BEGIN TOPIC-----
   
              
   
              1  
               ...              
                  
            ...    NewCustID                 
 
             
    
  
-----END TOPIC-----

Solution:
=======
-----BEGIN SOLUTION-----
     SQL
SELECT (Select Count(*) From Table1 Where Idn <= T1.Idn) AS SNumber, T1.* FROM Table1 AS T1;
  
-----END SOLUTION-----

Attachments:
============
SelfNumbering.zip
The (Attached) Solution Suggested By Eng. Usama El-Mokadem: http://www.arabteam2000-forum.com/index.php?showuser=98027

CONTACT INFORMATION:
=======================
  Eng. Usama El-Mokadem
  Email: musama@hotmail.com
  Web: http://musama.tripod.com
  Mobile: 0020 10 1289308
  Egypt
