concat strings on sum query

[Guest]

I need to write a sum query however one of the fields needs to be a
concatenation of the detail records.
for example
bob 10
chuck 20

would come back as
bob/chuck 30

I'm wondering if there is a way to do it with the query designer rather than
creating an ado recordset and manually sequencing through the records
thanks

 

[Van T. Dinh]

What do you want to do if you have 100 Records? 100 names separated by "/"?

 

[Guest]

In this particular case we know each string is 4 char long ( incld seperator
) and that there won't be more than 4 distinct detail records. But for the
general case you make a good point.

I was able to figure something out that works and wasn't too complicated so
I don't need a solution anymore


I hate replacing published reports, they have to be just 'so'

 

[Van T. Dinh]

I have just spent 3-4 days to do a Report with up to 10 SubReports and the
SubReports have snaking columns down and then across so that it looks like
an old print-out from Excel.