Numbering records in a report

  • Thread starter Thread starter DaveF
  • Start date Start date
D

DaveF

I have a report with orders grouped by customer and I want to consecutively
number all orders like this:

Customer x
1. order 12
2. order 15
3. order 20
Customer y
4. order 90
5. order 100
Customer z
6. order 1
7. order 3

Can anyone give me some guidance on how to do this?

Thanks
Dave
 
I have a report with orders grouped by customer and I want to consecutively
number all orders like this:

Customer x
1. order 12
2. order 15
3. order 20
Customer y
4. order 90
5. order 100
Customer z
6. order 1
7. order 3

Can anyone give me some guidance on how to do this?

Thanks
Dave
Click to expand...

Add an unbound control to the report.
Set it's Control Source to:
=1
Set it's Running sum to Over All.

The above will give you:
Customer x
1 order 12
2 order 15
3 order 20

If you need that dot after the number, you'll need to modify the
above.
Name that control CountRec.
Make it not visible.
Add another unbound control.
Set it's control source to:
= [CountRec] & ". "
 
Back
Top