quote:Originally posted by sal
You can also change the sorting on the actual report under sorting and grouping. That will utimatly determine the sort order.
Many thanks for ur guiding. From ur advice, I think it's all about experimenting the sort order possibilities both in queries and the report. I'll give it a try later and let u know the solutions.