Grouped Report using Wizard in Access then Modify

https://www.youtube.com/watch?v=5kB3qISqhPI

Access - Polish Reports

https://www.youtube.com/watch?v=5V-o7llsKHo

respectfully,
crystal

http://www.MsAccessGurus.com
connect to me, let's build it together

~ have an awesome day ~

On 7/12/17 4:31 PM, sigurd@solbakkn.com [MS_Access_Professionals] wrote:

To head off a possible question: the records for this report are from a   query - the underlying tables do NOT have redundant entries for NPAmt   and PerAmt.  Sigurd    On 2017-07-12 14:45, sigurd@solbakkn.com [MS_Access_Professionals]   wrote:

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        Links:  ------  [1]  https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/messages/116451;_ylc=X3oDMTJyYnZxYWo4BF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNjQ1MQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0OTk4OTQwNjE-?act=reply&messageNum=116451  [2]  https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/newtopic;_ylc=X3oDMTJlcnF1ZWllBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTQ5OTg5NDA2MQ--  [3]  https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/116451;_ylc=X3oDMTM4MWxkY2Y0BF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNjQ1MQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0OTk4OTQwNjEEdHBjSWQDMTE2NDUx  [4] https://yho.com/1wwmgg  [5]  https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJlN3Y2anAxBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ5OTg5NDA2MQ--  [6]  https://groups.yahoo.com/neo/groups/MS_Access_Professionals/members/all;_ylc=X3oDMTJmODJqb2RoBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzE0OTk4OTQwNjE-  [7]  https://groups.yahoo.com/neo;_ylc=X3oDMTJkcWptYnVzBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDk5ODk0MDYx  [8] https://info.yahoo.com/privacy/us/yahoo/groups/details.html  [9] https://info.yahoo.com/legal/us/yahoo/utos/terms/

    ------------------------------------  Posted by: sigurd@solbakkn.com  ------------------------------------      ------------------------------------    Yahoo Groups Links    <*> To visit your group on the web, go to:      http://groups.yahoo.com/group/MS_Access_Professionals/    <*> Your email settings:      Individual Email | Traditional    <*> To change settings online go to:      http://groups.yahoo.com/group/MS_Access_Professionals/join      (Yahoo! ID required)    <*> To change settings via email:      MS_Access_Professionals-digest@yahoogroups.com       MS_Access_Professionals-fullfeatured@yahoogroups.com    <*> To unsubscribe from this group, send an email to:      MS_Access_Professionals-unsubscribe@yahoogroups.com    <*> Your use of Yahoo Groups is subject to:      https://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

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