Beginner having problem with REPORT TOTALS

[rotcod]

I've read all the HELP stuff, but cannot find a step-by-step that shows me a simple way to insert a COUNT or TOTAL at the bottom of a report (in this case, it should just count the TOTAL number of problem reports in the report. I BELIEVE that SUM=Fieldname should work, but it gives me an #ERROR in that box when I run the report.

Can someone show me how to do it (please).

 

[dhookom]

To count the number of records in a report, use:
=Count(*)
in the REPORT FOOTER or HEADER (not PAGE)
To sum a numeric field in a report, use:
=Sum([NumericField])


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rotcod]

Duane... I inserted a TEXT BOX, & added the =Count(TRNO)... when I open the report, it says #error in the box???? Any ideas?

 

[dhookom]

Where did you add the text box and what is its name. It can't have the name of a field.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rotcod]

I added it in the FOOTER, per what Duane said. It shows up as UNBOUND, then I inserted the =Count(TRNO) into the UNBOUND frame... is it supposed to be entered in there another way?

Thx!

 

[Harr777]

I had a similar problem recently. The only way that I could get a total in the report footer was to add a text box in the page section with its value set to the numerical text box, the Running Sum property set to Group Over All and Visible set to No.
Then in the Report footer, made a new text box with its value set to the first (Visible set to true, of course).
This works fine for me, but it seems like there really should be a more direct way.

Harr

 

[rotcod]

Harr777,

This gets wierder & WIERDER. I tried your suggestion... still no luck with the FOOTER... BUT, when I put the text box in the HEADER, & use the same criteria you suggested (withOUT the non-visible box in the body of the report), it WORKS correctly.

Anybody got any other ideas?

 

[dhookom]

rotcod,
You have never provided us with the name of your text box. You said you put the control "in the FOOTER" but didn't tell us which footer. Your second to the last posting doesn't say what happens when you view the report.

Copy the control that works from the HEADER (you don't specify if this is page or report) and paste it in the Report Footer.

This is one of the most reliable, never known it to ever fail methods for getting report totals.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.