Numbering records in a report

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
 
F

fredg

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

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] & ". "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top