Thanks for reply. Let me explain it better. I have a Customer Statement with Invoice Date and Transaction Date on Statment one is on Group header and one on detail line underneath, but user wants them sorted as 1 column(see example) Do you know if this is possible The data is in an XML Epicor File which we don't really have control over to query . When I concatenate fields and sort it only sorts on first field , so they aren't really sorted on all fields
Now:
Grp Hdr 3/1/2010
Grp Hdr 10/1/2010
Detail Line 1/1/2010
Detail 2/1/2010
Grp hdr 1/1/2010
Desired: 1/1/2010
1/1/2010
2/1/2010
3/1/2010
10/1/2010