serial number

[JoeAcess]

hello everybody

how can i have a serial number in my report.. isthere a fn??

 

[namliam]

There is a fn if you create it...

 

[Atomic Shrimp]

A bit more information would help us to help you...

Exactly what do you mean by a serial number? (Is it just a sequential number you want, or are you wanting to generate some kind of alphanumeric serial code?)

Where do you want it to appear? (once per report? Once per detail line?)

Do you want it to have some kind of persistence or permanent relationship to the data or the report?

 

[JoeAcess]

i just want a sequential number for each record of data that appears on the report. starting from 1 it should continue till the end of the report, doesn't matter how much ever page it is.
Also since you asked how do i limit my numbers to one page and start afresh for a new page?
No permanent relationship to the data is required.
Also how do you generate the alpha numeric serial number?


Thanks a lot in advance

 

[sviggos]

i just want a sequential number for each record of data that appears on the report. starting from 1 it should continue till the end of the report, doesn't matter how much ever page it is.
Also since you asked how do i limit my numbers to one page and start afresh for a new page?
No permanent relationship to the data is required.
Also how do you generate the alpha numeric serial number?


Thanks a lot in advance

in order to show an automatic (if i understood correct it needs to be automatic) sequential number for each record of data,
you need to insert an autonumber field in your table where this record comes from.
Then by creating a query, you can add all the required fields for you report with additional the autonumber field .
then, just add as a record source in your report , the newly created query.
I am not sure if there is an automatic alpha numeric serial number

 

[Atomic Shrimp]

in order to show an automatic (if i understood correct it needs to be automatic) sequential number for each record of data,
you need to insert an autonumber field in your table where this record comes from.
Then by creating a query, you can add all the required fields for you report with additional the autonumber field .
then, just add as a record source in your report , the newly created query.

That's only going to work if the report needs to show every single record in the table in the precise order they were added to the table, and then only if there are no gaps in the autonumber sequence - which can happen easily.

There's a solution here for sequential numbering in reports.