Sorting

[Ernst Guckel]

Hello,

Any idea why my report does not sort right? It is supposed to sort by
LastReview.

SELECT tblEmployees.EmpID, tblEmployees.EmpFirst, tblEmployees.EmpLast,
tblEmployees.EmpStatus, tblEmployees.DateOfHire, tblEmployees.EmpFileNumber,
tblEmployees.EmpID, Format(nz(DMax("ReviewDate","tblReviews","[EmpID] = " &
[EmpID]),[DateOfHire]),"dd-mmm-yy") AS LastReview FROM tblEmployees ORDER BY
Format(nz(DMax("ReviewDate","tblReviews","[EmpID] = " &
[EmpID]),[DateOfHire]),"dd-mmm-yy");


Ernst.

 

[Rob Ward]

If your are outputting this query to a report, then you will need to set the
report order within the report - Access reports ignore/overwrite the order in
which data is presented to them from underlying queries.

The Sorting and grouping dialog is selected from the View menu in the report
design view.

 

[Ernst Guckel]

Good to know. You learn something new every day

Ernst.

If your are outputting this query to a report, then you will need to set the
report order within the report - Access reports ignore/overwrite the order in
which data is presented to them from underlying queries.

The Sorting and grouping dialog is selected from the View menu in the report
design view.
--
Rob Ward

Hello,

Any idea why my report does not sort right? It is supposed to sort by
LastReview.

SELECT tblEmployees.EmpID, tblEmployees.EmpFirst, tblEmployees.EmpLast,
tblEmployees.EmpStatus, tblEmployees.DateOfHire, tblEmployees.EmpFileNumber,
tblEmployees.EmpID, Format(nz(DMax("ReviewDate","tblReviews","[EmpID] = " &
[EmpID]),[DateOfHire]),"dd-mmm-yy") AS LastReview FROM tblEmployees ORDER BY
Format(nz(DMax("ReviewDate","tblReviews","[EmpID] = " &
[EmpID]),[DateOfHire]),"dd-mmm-yy");


Ernst.