Concatenate Field, order in which items appear

[cdoyle]

Hi,

I've created a report where I've concatenate a field to display the many side into 1 field, using the method found here
http://support.microsoft.com/default.aspx?scid=kb;en-us;141624


It's all working great, but I need the items in this field to not appear in alphabetical order, like they do now.

I need them to appear accending by the comments_used_ID in the comments_ holder table.

That should be possible right?

 

[khawar]

Tell me is it ok now

 

[cdoyle]

That looks great!

What did you do?

 

[khawar]

Just made ammendment in sorting and grouping and set it to
comments_used_ID---> ascending

 

[cdoyle]

In the report?

I thought I had tried that and it didn't work.
I also tried it in the query, the report is based off and didn't work for me there either.

oh well, it's working now
Thank you for your help.