Avatar of dnt2009
dnt2009 asked on

Access Query / Report Calculations

I'm new to Access and need assistance in developing some reports chow totals.
Basically need to show for each Account Manager, the total number of instructions received for option A and for option B.

It should look like this:

Total Number of Clients: 30

Account Manager 1
Option A: 5
Option B: 4
Total response: 9
Total Clients: 15
Outstanding responses: 7

Account Manager 2
Option A: 2
Option B: 1
Total response: 3
Total Clients: 15
Outstanding responses: 12

Can anybody help out with guides to how I manage this type of Reporting?

Thanks,
dnt
Microsoft AccessSQL

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Barry Cunney

Do you have a table that already stores data relating to the above?


First create a query to the ReportSource
This query will possibly have to be something like:

SELECT
AccountManager
,Option
,SUM(Response) [Total Response]
,SUM(Clients) [Total Clients]
FROM [Client_Instructions]
GROUP BY
AccountManager
,Option

Save this query - this query will be the reportsource for your report
Put the account manager field in a Account Manager header section  and the option field in the detail section of a report
Put Total Responses and Total Clients in a a Account Manage Footer section on the report
ASKER
dnt2009

I've attached a sample file.
Sample-File.accdb
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
dnt2009

Thanks Jeff. It took me aa while to figure out how to do these calculations but I've been able to replicate the model for other calculations.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jeffrey Coachman

Great, ...glad I could help.

;-)

Jeff