Serial number for reports

Insert a unbound field to your report "txtSerNr" an set the ControlSource to

=1

Change the property "RunningSum" of this field to "All" or "Group", depending for what you need the sum.

Can you explain further what you mean by "serial numbers"? Is this data that would be stored in your database, or are you just wanting to add numbers (as coffeeshop suggests) to your reports?

or are you saying that you want to number each running of a report so that it can be identified?
JimD.

it should be stored in database

vijju284,

Again, you are not being very specific here.
Can you clearly explaion what you are trying to accomplish here, in a bit more than one short sentence, please?
This way you are not forcing us to guess.

This saves both you and us valuable time.

JeffCoachman

I am trying to generate bills from MS Access reports by using perameter querries.   If I save the bill by using command button it should store in a table and it should generate serial number for each report automatically.

Do you need consecutive numbers or should they include something special?

Please post your query so that we can take a look which approach is better. You can do it with a join in your query, if you have a unique key in your table(s), or you can create it with a custom function.

consecutive numbers only

If you have a unique key, here an example without grouping:

SELECT A.*, (SELECT COUNT(*) FROM tblYourTable AS B WHERE B.YourKeyField<=A.YourKeyField) AS SerNr
FROM tblYourTable AS A;

where should i give the statement

This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.