'group/combine' similar query results with a + symbol in datasheet view

[Shecky]

I have a simple query that lists order history, one record for each Order Detail. I want to group all the same customer orders with a '+' (that acts as a dropdown) so that it will shorten the list and make it easier to view. In the above example All those records would combine into one and clicking on the + will expand the list. I know access does a similar thing when you have a sub table such as order details. All the Details are combined under one under number with a +.

 

[arnelgp]

you put it in a Form, so it will be easy to code what you need to accomplished.
or you can put (insert) the "summary" in a table. the summary table must have relation
to your "detail" table.

 

[theDBguy]

Hi. So, why can't you use subtables (as you called it)? Don't you have a separate Customers table?

 

[MajP]

If you do not have a table so can simply do a query that returns each company name and anything unique to that company. From that query you can add "saleshistoryquerybyregion" as a subdatasheet. Set the link to companyname. You can add a sub data sheet to any query just like you can to a table. Since this happens often automatically, many people do not know how to add them manually. See bottom right if not familar. It is the same as linking a subform.