Line numbers in Access Report/Form

A

Antje

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).
 
F

fredg

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
 
S

siric

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 ?
 
D

Duane Hookom

Considering Fred's reply, where do you get lost/confused? The control source
and running sum are both properties of the text box.
 
Top