total number of count on report

[DevAccess]

Hello

I would like to show number of records in reports and also I would like to display only one record, i am showing all the records tabularaly and would like to have only first records from the given report query.

For total number of count on report I already tried =count(*) and also tried =count ([student_id])

It is not working, please advise.

 

[Ranman256]

do the math in the query.
make a query that does the count, join it to your report query.
then the total and detail are both in the report.
or
the report also has SUM and COUNT you can use in the grouping footer...
txtbox = COUNT([field])