Sort order within the Report

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

I want to be able to have a report in a preset order, what I have done at
the moment I have put some sql in the Record Source field which is:

SELECT tblTroubleshoot.IngTroubleshootID, tblTroubleshoot.dtmOpenDate,
tblTroubleshoot.dtmCloseDate, tblTroubleshoot.txtPriority1,
tblTroubleshoot.txtPriority2, tblTroubleshoot.txtUser,
tblTroubleshoot.memNotes, tblTroubleshoot.txtSolved
FROM tblTroubleshoot
WHERE (((tblTroubleshoot.dtmCloseDate) Is Null) AND
((tblTroubleshoot.txtSolved)=No))
ORDER BY tblTroubleshoot.txtPriority1 DESC;

When I run this as a query it sorts on the txtPriority1 field, but when I
run the Report the sort order dont work, can anyone please explain why.

Many thanks,

Graham.
 
I believe that the report sorts the dynaset of your query based on it`s on
criteria. You can alter this via the 'Sorting and grouping' button on your
toolbar.

George Papadopoulos
 
Many thanks, it worked fine.

George Papadopoulos said:
I believe that the report sorts the dynaset of your query based on it`s on
criteria. You can alter this via the 'Sorting and grouping' button on your
toolbar.

George Papadopoulos
Click to expand...
 
Many thanks, it worked fine.

George Papadopoulos said:
I believe that the report sorts the dynaset of your query based on it`s on
criteria. You can alter this via the 'Sorting and grouping' button on your
toolbar.

George Papadopoulos
Click to expand...
 
Back
Top