Sorting

  • Thread starter Thread starter Ernst Guckel
  • Start date Start date
E

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.
 
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.
 
Good to know. You learn something new every day :)

Ernst.


Rob Ward said:
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


Ernst Guckel said:
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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Query 1
Unexpected results when sorting multi-table query using toolbar button 5
Sorted and Unique Date Period 2
Should be simple but... 21
Ok This one is Tuff 3
sorting date in crosstab query 1
DataGrid Sort Expression for a date in format 'dd mmm yy' 4
sort by month out of sequence 4

Back
Top