[AccessD] Total in Footer of Report

It is in a group footer.

Paul

At 02:40 PM 3/18/2003 -0500, you wrote:
>Paul,
>
>Which "footer" contains the total?  It should be in a group footer, not a
>page footer.
>
>Joe O'Connell
>joconnell at indy.rr.com
>
>-----Original Message-----
>From: Paul Liadis <pnl1 at psu.edu>
>To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
>Date: Tuesday, March 18, 2003 2:27 PM
>Subject: [AccessD] Total in Footer of Report
>
>
>|Hi all,
>|I have an Access report in which I want to display a total in a
>|footer.  The total is fine on the first page, for the first location.  Once
>|the report hits the second location, however, the total does not get
>|initialized and adds to the previous location's total.  I would like to
>|initialize the textbox that displays the total after every
>|location.  However, Access won't let me change the textbox's text property
>|to be equal to zero.  I am using the following code:
>|
>|me.txtFoo.setfocus
>|me.txtFoo.text = 0.
>|
>|Please give me some advice on how to accomplish what I am trying to
>|accomplish.  Am I EVER able to set the text property of a textbox in a
>Report?
>|
>|Thanks in advance,
>|
>|===============================================
>|Paul Liadis
>|Senior Applications Programmer/Analyst
>|University Budget Office
>|Pennsylvania State University
>|
>|_______________________________________________
>|AccessD mailing list
>|AccessD at databaseadvisors.com
>|http://databaseadvisors.com/mailman/listinfo/accessd
>|Website: http://www.databaseadvisors.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com