how to insert Serial No (Row)

could anybody tell me how to insert a Serial no in microsoft access97.
my problem when i am creating reports in Access97 i am unable display Serial numbers for each field at the left most(First column). is theire any function or logic in access to display serial Nos.if so please le me know.
report i want like this
         XXX   ZZZZ

                1      aaaa   aaa
                2       sss   ss

                i want to display row

Thank in advance,

Who is Participating?
tsotakConnect With a Mentor Commented:
Don't use for the field name. Full-stop is invalid character. Then use an Autonumber type for that field.
Look at the same your question in MSOffice area for my solution. You can delete this (or that) question to save your points.
Good luck!
hmkAuthor Commented:
please close this question. don't need this

thankyou for your help.

To close this question, reject tsotak answer and delete question. If my solution in MSOffice area satisfy your needs, accept my answer. If not - I'm waiting for your additional comments.
Good luck!
P.S. If due to some reasons (browser proplems etc.) you can't delete your question, you can post 0-points question in Customer area to ask Customer support service to delete question.

This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
Thank you,
Moderator @ Experts Exchange
All Courses

From novice to tech pro — start learning today.