We help IT Professionals succeed at work.
Get Started

Multiple Record Source Report

axla
axla asked
on
501 Views
Last Modified: 2012-05-05
Listed below is a sample of an Excel based report I am trying to reproduce in Access:

Line No      Group      SubGroup            Jan      Feb      Mar      Year Total

1      Group1                                    
2            SubGroup1            11      22      3      36
3            SubGroup2            33      7      19      59
4            TotGrp1            44      29      22      95
5      Group2                                    
6            SubGroup3            14      5      4      23
7            SubGroup4            28      77      8      113
8            TotGrp2            42      82      12      136
                                          
9            TotGrp1-2            86      111      34      231
10                                          
14      GroupA                                    
15            SubGroup5            100      85      68      253
16            SubGroup6            120      55      44      219
17            TotGrpA            220      140      112      472
18      GroupB                                    
19            SubGroup7            220      140      112      472
20            SubGroup8            172      222      68      462
21            TotGrpB            392      362      180      934
22            TotGrpA-B            612      502      292      1406
23                                          
24            TotalAll            698      613      326      1637



While the data is in the same format, in our report filing, each section is displayed separately.  I know how to reproduce the SubTotals and Totals, and I've created separate queries for each "SubGrouping, but I'm struggling with how to combine the data on one report.  Is this possible with Access?

axla



Comment
Watch Question
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE