Sorting Records in a report!!

[MarkNie]

Hi All

Hope you are doing well.

I am having a problem getting the sorting right on my report, well not even sure if this is possible.

What I am trying to do is get the records to sort in accending order by the Date and then sort it by portfolio code so that it looks something like this:

11/06/06 23026
11/06/06 23027
11/06/06 23030

I get this right in the query that I use but as soon as I open the report with the query it throws it all out or it just sorts it by the Date.

The SQL that is in the query which works fine but as soon as I open the report with the query it throws the portfolio code around:

SELECT qrybBookstoberun.RunDeadline, qrybBookstoberun.PortfolioCode, qrybBookstoberun.ProductType, qrybBookstoberun.ClientName, qrybBookstoberun.qrybAttn.Date, qrybBookstoberun.qrybIP.Date, qrybBookstoberun.qrybSLA.Date, qrybBookstoberun.[ABBA Booklet]
FROM qrybBookstoberun LEFT JOIN qrybRun ON qrybBookstoberun.TrackingID = qrybRun.TrackingID
WHERE (((qrybRun.Action) Is Null))
ORDER BY qrybBookstoberun.RunDeadline, qrybBookstoberun.PortfolioCode;


Any ideas or help would be great.

Thanks
Regards
Mark

 

[MarkNie]

Hi All

Just answering my own question, maybe sometimes one should just open there eyes!!

What you have to do is go into the report in design view, then select the whole report and go to the properties box. Type in the fields you want sorted in the Order By option and Order By On.

Thanks for listening..

Cheers
Mark