Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Report Calculations


Message #1 by "Jamie Kriegel" <jamiek@m...> on Fri, 21 Mar 2003 16:35:37 -0600
I was hoping someone could help me with a report calculation.  I have a
calculations (a net total) in one footer in my report and I want a sum of
that net total in the footer directly below it.  I can't seem to figure out
how to make it work.  Any ideas?

Thanks,
Jamie

-----Original Message-----
From: Joseph Valdez [mailto:e-valdez@a...]
Sent: Friday, March 21, 2003 11:10 AM
To: Access
Subject: [access] Re: How to place percentages in chart


How? May I ask.

Thanks-Joe

-----Original Message-----
From: zak willis [mailto:zak@z...]
Sent: Friday, March 21, 2003 2:01 PM
To: Access
Subject: [access] Re: How to place percentages in chart


Yes
> Hello there,
Is there a way to place percentages in a chart?

Thanks Access Buddies!






Message #2 by "Maha Arupputhan Pappan" <mahap@p...> on Sat, 22 Mar 2003 01:49:10
First of all, turn on your Footer A (whatever grouping) and Report Footer.

In Footer A
1. Insert a text box with the following attributes:-
	a. Control Source: Sum([FieldName])
	b. Name: NetTotal
	c. Left: 3"
	d. Caption: Net Total

In Report Footer
1. Insert another text box with the following attributes:-
	a. Control Source: Sum([FieldName])
	b. Name: GrandTotal
	c. Left: 3"
	d. Caption: Grand Total

  Return to Index