UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Report To Show Multiple Levels, Access 2016    
 
   
geoffk7828
post Jul 30 2019, 02:25 AM
Post#1



Posts: 25
Joined: 21-October 06
From: Barossa Valley South Australia, Australia


Hi All,
My objective is to have a report that will display in several levels as detailed below:
Technician Name
Task-1 Total Number of Task-1
Task-2 Total Number of Task-2

i.e.
Bob Down
Installation 12
Service Call 4

Barney Rubble
Installation 8
Service Call 6

This data comes from a query (Customers_Completed) the fields are [Tech_Name] and [Job_Outcome].

I have searched the internet and have tried several ways but cannot get the results that I need.

Any help would be gratefully appreciated

Geoff
Go to the top of the page
 
 
Start new topic
Replies
GroverParkGeorge
post Jul 30 2019, 06:28 AM
Post#2


UA Admin
Posts: 35,888
Joined: 20-June 02
From: Newcastle, WA


"...and have tried several ways but cannot get the results that I need."

Can you be more specific about the things you have tried and about the reasons they did not provide the results you need? There's no point in anyone suggesting something you already tried....

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
RJD
post Jul 30 2019, 10:35 AM
Post#3


UtterAccess VIP
Posts: 10,095
Joined: 25-October 10
From: Gulf South USA


Hi Geoff: Since we can't see what you have tried, or what your query results actually look like, we'll have to make some assumptions. I assume, from what you posted, your query is a long list of records with repeated names and outcomes ...

Bob Down Installation
Bob Down Installation
Bob Down Installation
Bob Down Installation
...

etc.

If this is correct, you can get what you want by first using a Totals query to group on tech name and on outcome, and count, say, outcomes. This produces ...

Bob Down Installation 12
Bob Down Service Call 4
Barney Rubble Installation 8
Barney Rubble Service Call 6

Then, in a report, you can group on the tech name (as suggested by June7) and use the other fields in the detail section.

You could do all this in the report (multiple group levels with counts, leaving out the Detail section), but this seems a simpler approach.

See the demo attached, using your posted data, and my assumptions. Let us know if this is close to your requirement, or provide more details if not.

HTH
Joe
Attached File(s)
Attached File  MultipleLevelsReport.zip ( 21.38K )Number of downloads: 7
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
projecttoday
post Jul 30 2019, 04:33 PM
Post#4


UtterAccess VIP
Posts: 11,075
Joined: 10-February 04
From: South Charleston, WV


If your levels are represented by various tables then you might use subreports.

--------------------
Robert Crouser
Go to the top of the page
 
geoffk7828
post Aug 1 2019, 11:25 PM
Post#5



Posts: 25
Joined: 21-October 06
From: Barossa Valley South Australia, Australia


Thank you All for your replies.

I now have this working successfully.

Again thank you
Go to the top of the page
 
RJD
post Aug 2 2019, 09:53 AM
Post#6


UtterAccess VIP
Posts: 10,095
Joined: 25-October 10
From: Gulf South USA


Glad you got that working. We were all happy to assist.

Continued success ...

Regards,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    20th October 2019 - 07:08 AM