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!
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