concat strings on sum query

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

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
 
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'
 
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.
 
Back
Top