Report Summary

L

LG

I built a query with the following:
Date ID Num of Clms (control source= countofbatchid)

I created a report and would like to have the total number of claims. I
know I need to put it in the footer of the report but can not figure out how
with out getting an error.
 
J

John Spencer

Add a text control to the report's footer (not the page footer)
Set the control's control source to

=Sum([CountOfBatchId])

If that does not work, post back and tell use how it didn't work?
An error message (what is the message)?
Wrong result (what is the result and what did you expect to see)?
No result (just blank)
etc.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
L

LG

That said:
Add a text control to the report's footer (not the page footer)
Set the control's control source to

=Sum([CountOfBatchId])

If that does not work, post back and tell use how it didn't work?
An error message (what is the message)?
Wrong result (what is the result and what did you expect to see)?
No result (just blank)
etc.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I built a query with the following:
Date ID Num of Clms (control source= countofbatchid)

I created a report and would like to have the total number of claims. I
know I need to put it in the footer of the report but can not figure out how
with out getting an error.
Click to expand...
Click to expand...
 
Top