Count(*)

[cyraxote]

Hi.

I hope this is a simple question.

I am using Access 97. I want to count the number of records in a report. Access help says:

1 Open the report in Design view.
2 Add a calculated text box to the report header or footer.
3 To display the property sheet, make sure the text box is selected, and then click Properties on the toolbar.
4 Set the ControlSource property of the text box to =Count(*). This expression uses the Count function to count all the records in the report even if some fields in some records are Null.

I have done all of these things, but the report shows "#Error."

Is it unreasonable to expect the Help files to actually be helpful...?

Any solutions would be greatly appreciated.

Thank you.

Rodney

 

[Pat Hartman]

The instructions are correct. Have you perhaps put the control in the PAGE footer rather than the REPORT footer?

 

[cyraxote]

I don't have it right in front of me, but that's possible. I don't think that report has anything in the report footer.

I'll check, but in the meantime, thanks very much.

 

[NShafranski]

Count(*) will count NULL values as well.