concat strings on sum query

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

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

--
HTH
Van T. Dinh
MVP (Access)


"Mike" wrote in message
...
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'


"Van T. Dinh" wrote:

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

--
HTH
Van T. Dinh
MVP (Access)


"Mike" wrote in message
...
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

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.

--
HTH
Van T. Dinh
MVP (Access)




"Mike" wrote in message
...
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'