Joe O'Connell
joconnell at indy.rr.com
Tue Mar 18 13:41:00 CST 2003
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