I have a query based on a table with the fields such as firstname and lastname. I am running a report which list down all the records. But I want to print a row number / serial number as first column in the report.

Sample

SL. No. FirstName LastName

1. Sam Noel
2. Manz Nishad
3. Prav Jeevan

Please note that this SL.No is not a bound column to database. This has to be generated while running the report.

Any idea guys? Please reply.

What platform are you working in? That's a key piece of info.

I was using MS Access 2000 on windows 2000.

I got the solution and it can be done this way.

Insert text box in detail portion of the report and in the properties of the textbox in Data Tab make the Control Source as '=1' and then Change the Running sum as 'overall'.

It works!

Yep there is a Microsoft article about doing "running sums" that can be used to do what you want. Had you mentioned what platform you were using in the original note, I would have pointed you towards that solution.

The point being that you should always include certain pieces of info when asking a question. If asking about using a piece of software give the software name and version. Its always a good idea to include OS version. When asking about hardware give the brand and model. Its usually best to err on the side of too much info then not enough.

Hi ScottGem,

Didn't include the platform which I was working on while posting the thread. Sorry for that. Will include in future while posting. Thanks.