number column and total in footer

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

am not having any easy trans from 03 to 07

in a report I'd like to add a number column -- simply 1,2 3... etc.

and have a total of all the records in the footer.

any advice much appreciated.

Sal
 
On Mon, 27 Jul 2009 13:36:02 -0700, Sal

That's done exactly the same way in 07 as it was in 03.
Create a textbox in the Details section and set the controlsource to:
= 1
and set the RunningSum property.
In the footer create a textbox and set the ControlSource to:
=count(myField)
(replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
 
Back
Top