[MS_AccessPros] Report subtotals and totals

 

I have a report for which I want to calculate some totals, and don't
know how to put together the proper equations to do that.
The individual records include fields GID, Cat, and Actual.
The report is grouped on GID (Grant ID) and Cat (Category). I have the
report calculating the sum for Actual in the footer for Category. There
are two categories, N (Non-Personnel) and P (Personnel). Each category
has a maximum billable, NPAmt and PerAmt, respectively. (Each grant has
a single value for each maximum; those values are repeated in every
record, hence available for use in calculations.

In the footer for the category, I show, in addition to Sum(Actual), the
appropriate maximum, and then the lower of the two figures as the amount
actually billed for that category.

I would like to have an accurate grand total billed for each grant, but
need to compare the individual subtotals against the appropriate max,
rather than comparing Sum(Amount) for the whole grant agains the sum of
the category maximums. The calculation would be on the order of:
Min(Sum(Amount) for category N,NPAmt) + Min (Sum(Amount for category P,
PerAmt).

Any help on the syntax for this calculation would be greatly
appreciated.
Sigurd Andersen

__._,_.___

---

Posted by: sigurd@solbakkn.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___