Line numbers in Access Report/Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I like to print an address report in alphabetical sequence and would like
Access to generate a line number either in "report" format or as a "form" so
at the end I know how many name (line I have).
 
I like to print an address report in alphabetical sequence and would like
Access to generate a line number either in "report" format or as a "form" so
at the end I know how many name (line I have).
Click to expand...

If you simply wish to know how many records were on the report, all
you need do is add an unbound control to the report footer.
Set it's control source to:
=Count(*)

If you actually wish to have a number increment alongside each record,
add an unbound control.
Set it's control source to
=1
Set it's running sum property to
Over All
 
If I want to include the line numbers along side with each record, How could
I set the control source and the running sum property to overall ? May I have
your assistance ?
 
Considering Fred's reply, where do you get lost/confused? The control source
and running sum are both properties of the text box.
 
Back
Top