Numbering a list generated by Access in a Report

D

DeeAnna

Please, please...How do I get my list that is generated as a report in
Microsofts Access to be number. I have a large DVD list in this report and I
would like it to show how many DVD's are on this list.
 
R

Rick B

Did you do a search? This is a VERY common question. Please read the
previous posts - that's why they are retained.
 
J

John Spencer

Open the report in design view
Add a control to the detail row
Set its properties as follows:
Control Source: =1
Running Sum: OverAll

That will automatically number each row with a 1-up number

If you want just a count of the records.

Add a control in the report footer (if you don't have a report footer then
add it by selecting View: Report Header/Footer from the Menu.)
Set the control's control source to : =Count(*) & " DVDs"
 
Top