Write a loop that cycles through each record from first to last and create your serial number however you see fit. Or you could simply save the data back into another table that had an autonumber for the serial number field and it would do basically the same thing granted with a lot less control but that depends on how versitile you need it to be.
--- dasaga_phani <[EMAIL PROTECTED]> wrote: > Say, A query generating 10 records. Now what I need > serial no. > > Like this > > 1. First record > 2. second record > 3. third record > ... > 10. tenth record > > How can i achieve this. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
