Count in report footer

G

Guest

I am very new at this.

I have added a text box to my report footer and changed the control to
=Count(*) to get a total count of the records in the report, however when I
run the report I get an error ..... #Error.
 
G

Guest

Firstly check you are in the Report Footer and not the Page Footer.
Your control source should read =Count([FieldName]) maybe you have omitted
the square brackets?
HTH Sheila
www.c-i-m-s.com
 

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

Similar Threads

Count in a Report Footer of a Report 2
A03 - count in report footer gives me #Error? 0
Access MS Access DCount function problem 0
How to count records using count(*) in a chart report 3
Calculations in Group Footer 7
count in parent report footer 2
Access MSACCESS - Sorting report based on field calculated in the report 0
JS-Q7: Counting records in report 2

Top