Autonumber in a report

  • Thread starter Thread starter Radhika
  • Start date Start date
R

Radhika

I have a report with draws items from a table with an autonumber field. This
field numbers all the records I have. In my report, however, I have the
records grouped differently from the table. I want to insert a seriel number
function in the report so that each record is numbered consecutively.
For example

Sr. No. Name of person
1. AAAAA
2. NNNNN
3. MMMM

How do I insert a control similar to autonumber in tables, in the report.

Thank you,
Radhika
 
I have a report with draws items from a table with an autonumber field. This
field numbers all the records I have. In my report, however, I have the
records grouped differently from the table. I want to insert a seriel number
function in the report so that each record is numbered consecutively.
For example

Sr. No. Name of person
1. AAAAA
2. NNNNN
3. MMMM

How do I insert a control similar to autonumber in tables, in the report.

Thank you,
Radhika
Click to expand...

I'm not sure I understand what you mean by 'serial number', but
perhaps this will be what you want.

Add an unbound control to the detail section.
Set it's control source to
=1
Set it's Running Sum property to
Over All

That should be all you need to number the printed detail records.
 
Radhika said:
I have a report with draws items from a table with an autonumber field.
This
field numbers all the records I have. In my report, however, I have the
records grouped differently from the table. I want to insert a seriel
number
function in the report so that each record is numbered consecutively.
For example

Sr. No. Name of person
1. AAAAA
2. NNNNN
3. MMMM

How do I insert a control similar to autonumber in tables, in the report.

Thank you,
Radhika
Click to expand...
 
Back
Top