[AccessD] URGENT: Report Sum of the group shifted for one record

Ervin,
 
Write an aggregate query that sums the field in question and use that as
the datasource for the header field.
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
(SELECT * FROM users WHERE clue > 0) 

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Wednesday 2003 Feb 26 07:17
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] URGENT: Report Sum of the group shifted for one
record


Order of Sections in a Report:  Group Header -> Detail section -> Group
Footer
 
What you are trying to do is impossible because the running sum of the
current group isn't known until AFTER the Detail section runs.
 
Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com

	-----Original Message-----
	From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Ervin Brindza
	Sent: Wednesday, February 26, 2003 03:47 AM
	To: AccessD at databaseadvisors.com
	Subject: [AccessD] URGENT: Report Sum of the group shifted for
one record
	
	
	Cross posted Access-L AccessD
	Please help me, I'm desperate :(
	I want to sum the values from a text box in the Detail Section,
and to put that sum in the text box in the Group Header.
	In the group header is an unbound text box Text76 
	In the Detail  section is the text box
UkSalDug=IIf([txtSaldo]>0;[txtfld1]-[txtfld2];0) with Running Sum: Over
All
	In the code for Group Footer I want to pick this value with: 
	Me.Text76 = Me.UkSalDug
	But the Me.Text76 always get the sum of records of the previous
group :(
	So, I want:
	John 100
	40
	50
	10
	Peter 200
	120
	80
	Instead I get:
	
	John 0
	40
	50
	10
	Peter 100
	120
	80
	I can't do that in the report's record source, must be done
directly at the report.
	Can anyone offer a ray of light please?

	Many TIA,

	    Ervin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030226/dac3feaa/attachment-0001.html>