I have a report that has a record source of a parameter query. The report prints all the detail rows associated with this parameter value. I have been requested to put a 'record count' at the bottom of the report. I have been fooling around with this about 2 hrs now and can't get it to work. Any suggestions would be appreciated!!
-
-
In the detail footer, put a text box with a control source something like this:
Code:=Count([AnyOneOfYourFieldsHere])
-
DSatino's pretty well right, but I suspect you need to give the name of one of the form's controls rather than one of the fields associated with the RecordSource. Otherwise it's as simple as he says.
PS. Just noticed that the section advised isn't a possible one (Detail and Footer are separate sections). It would go in the report footer.Comment
Comment