Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count of records

Status
Not open for further replies.

696796

Programmer
Aug 3, 2004
218
GB
hi, ive just stated creating reports so am quite an amatur on the subject. i would like either:-

a count of all the records the report generate - say a txtbox at the bottom.

or

a number next to each record brought up

thanks for your time + effort

regrads,

Alex
 
Alex,

Add a text box to your report footer whose control source is:
Code:
=Count(*)

Hoc nomen meum verum non est.
 
To number your records in the detail section add a text box with the following properties:
Control Source: =1
Running Sum: Over All (or Over Group)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top