A03 - count in report footer gives me #Error?

S

StargateFan

I tried setting a text box in a Page Footer to show the total number
of records in a report but I'm getting the #Error in the footer and I
don't know how to fix it.

I followed instructions from here,
http://www.ehow.com/how_7444212_count-ms-access-2003-report.html,
which is the way I've done it before. Don't know why #Error never
came up before though the code does work if it's put in the Report
Footer which is no good.

The Report Footer places the total # of records floating in the middle
of the last page at the end of all the records. Is there no way to do
some sort of counting that will work in the Page Footer, please?
(Even the Page Header doesn't work.) I've upt the code into Report
Header for now but would be ideal best to put something in the Page
Footer.

p.s., unbound text box has this:
="Total Number of Records: " & Count(*)

Thank you!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top