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?

Tell me is it ok now

That looks great!

What did you do?

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

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.