|
View Full Version : Report Counter shariefoo 10-24-2003, 11:57 PM 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 10-25-2003, 01:56 AM Number of fields or records? shariefoo 10-25-2003, 02:31 AM 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 10-25-2003, 03:12 AM =Count(*) as the control source of an unbound textbox in the report footer jakehale 11-04-2003, 08:39 AM 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 11-04-2003, 09:33 AM Where on the Report are you putting the textbox? jakehale 11-04-2003, 11:14 AM It was my mess up,, ,i finally got it working using the dcount function..... thanks for your response and help... :D |