[AccessD] Total in Footer of Report

I sounds like you want a group total for the location group.  To do that:
1.  Put our location total textbox in a location footer and set the
ControlSource to =Sum([detailquantity]) where the detailquantity is the name
of the field in the underlying query.  Best to make sure the name of the
textbox that is bound to the detailquantity in the underlying query or table
is different from detailquantity.
2.  On the textbox, set the Running Sum property to No.  (this might be the
only problem with what you have now)


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Paul Liadis
Sent: Tuesday, March 18, 2003 2:19 PM
To: accessd at databaseadvisors.com
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