Accomplish Combined Cost in Report or Start in Query? 1

[Elvis72]

I have data that has up to six records for one invoice, I need to run a report that rolls them all up into one line item and gives me combined totals for each.

But I am at a loss as to where to start?

Right now I have:

Invoice Number Location Client Descpription Total Invoice Total Amount
1234 New York XX XXX 46.56 23.34
1234 London XX XXX 345.56 234.34
1234 Australia XX XXX 200.98 56.34

What I need is:

Invoice Number Location Client Description Total Invoice Total Amount
1234 NY, AU, LD XX XXX 593.10 314.02

Any help is appreciated

 

[dhookom]

Do you have any table that states London = LD and New York = NY? If not, create one so you can "swap" the values.

Then check the FAQs in the queries forum to find a generic concatenate function that can be used to combine multiple child values.

Duane MS Access MVP
Now help me support United Cerebral Palsy