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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count records in reports 1

Status
Not open for further replies.
Oct 19, 2004
31
US
I am trying to count records in a report. I made a text box and called it "Count".
In the properties of "Count" I set the Data >Control Source to =Count().

It gives me the total of all records and not actually counts the records.

I want the output to be

1 - Item 1
2 - Item 2
etc

Instead I am getting

2 - Item 1
2 - Item 2

It is summing the count and not actually counting.
Please help.
 
So you're looking for a running count of records?
Set the Control Source to =1.
Then set the RunningSum property to Over All.

I am what I am based on the decisions I have made.

DoubleD [bigcheeks]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top