Grouping Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've had a good scroll through this discussion group and can't find the
answer so apologies if I've missed it and just point me in the right
direction...

I have database which looks a little like this:
Customer ContractSupplier ContractType MeetingDate MeetingAction
Cust1 ABC ABCD 123 1234
Cust1 DEF DEFG 567
5678
Cust2 XYZ XYZA 912
9123

(Detail is irrelevant!)
I've produced a report of this info which works well EXCEPT - I've created
boxes for all the contract details and then underneath a load of boxes for
the meeting details. However, I'd like it to print so it lists all the
contract details attached to a customer, then all the meeting details
attached to the same customer. At the moment, its showing 1 contract detail,
then 1 meeting detail then another contract detail and so forth. I've tried
grouping, sorting and playing with the settings but can't work this out.

Sure this is something simple that I'm missing!
Thanks in advance
 
I think you might want to consider using a subreport. However, I don't know
your table and field names and other significant information. You have shown
us what your "database" looks like but we don't know if this is a table or
what. It would also help to know how you would expect that information to
appear in your report.
 
Make two subreports - one for contract details and then one for meeting
details. Group the main report on customer.
 
Back
Top