0

I currently have a report with a group value-indexes and the details of those value-indexes. ex:

a
   Harry 
   Potter               
b                
   Harry                        
   Potter
c
   Ron               
   Wesley

a,b,c are value index of a group and the names are values from details. I'm trying to avoid repetition of details-value. So:

a,b               
   Harry             
   Potter
c
   Ron
   Wesley

How do I achieve this? EDIT: I reformatted the example to better understand what's going on

Kenny Nguyen
  • 222
  • 2
  • 13
  • Your table has columns a, b and c or rows a, b and c? – Hambone Dec 09 '15 at 04:04
  • Possible duplicate of [Microsoft Access condense multiple lines in a table](http://stackoverflow.com/questions/5174362/microsoft-access-condense-multiple-lines-in-a-table) – Hambone Dec 09 '15 at 12:54
  • Should note that this is a report, not a table. – Kenny Nguyen Dec 09 '15 at 13:14
  • All reports are bound to recordsources either tables or stored queries. Can you post the table structure or query statement? – Parfait Dec 09 '15 at 13:59
  • I don't see how posting the query would help, I just want 2 groups with identical sub-group values to merge together just like in the example. The example given above is a summed up version of my query. – Kenny Nguyen Dec 10 '15 at 15:12

0 Answers0