Grouping w/ Multiple Columns

  • Thread starter Thread starter I3igDmsu
  • Start date Start date
I

I3igDmsu

I am creating an Access Report and I am starting off by using th
Wizard. I want to group with multiple columns for example...
Group 1: CustomerID, FirstName, LastName
Group 2: LoanID, Amount, IRate, Term, Interest
Group 3: PaymentRec, Date

How do I group these columns together, when I add the columns I a
unable to add more than 1 column per grouping
 
Not sure I understand, but I noticed that you have CustomerID, FName & LName
as a "group with multiple columns". I'll hazard a guess that once you have
CustomerID, you only have one FName & LName. If so, you actually only need
to "group by" CustomerID. And there's no reason you couldn't also add the
FName and LName fields in the actual GroupHeader, along with CustomerID.

Similarly, I suspect LoanID is the only field in your second Group that you
need -- the rest look like they "describe" a single LoanID.

For the PaymentRec & Date, this seems like there could be many -- why isn't
this a "Detail Section" item?

If I've misunderstood, please post more information.
 
Back
Top