Link to home
Create AccountLog in
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
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

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
Avatar of dnt2009
dnt2009

ASKER

I've attached a sample file.
Sample-File.accdb
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dnt2009

ASKER

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.
Great, ...glad I could help.

;-)

Jeff