Report Counter

[shariefoo]

God Morning All,
Can anyone please help ?

I am looking for a way to insert a counter inside the report so that it can count the feilds it just generated ?

Thanx All

 

[Rich]

Number of fields or records?

 

[shariefoo]

Number of feilds.. Aren't they the same?

I mean you have a report that lists IDs and Names.. I want the report to list the number of IDs in the report .. Or the names.. (Its the same)

 

[Rich]

=Count(*) as the control source of an unbound textbox in the report footer

 

[jakehale]

HUM

Rich, I have tried this and i get ERROR on the report....

what i am doing is trying to count the number of rows in a colum on my report, i insert a text box, go to properties and for control sourse i enter =count (*) and get error,, ,OR if i enter =count(row name) i get error.......

am i doing something wrong?

 

[Rich]

Where on the Report are you putting the textbox?

 

[jakehale]

thanks

It was my mess up,, ,i finally got it working using the dcount function..... thanks for your response and help...