sort order in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

In need to order the results from hours worked field from the highest to the lowest to show employees that have worked the most hours to the least hours on a specific date.I have already tried the acending/decending feature in query but the results dont reflect this in either query or a report run from this query.Is there a expression or criteria i need to set in this field???Thanks
 
To sort a report, you must use the sorting and grouping in the report. If
you want your query to sort, then provide us with the SQL view.

--
Duane Hookom
MS Access MVP


joe said:
hello

In need to order the results from hours worked field from the highest to
Click to expand...
the lowest to show employees that have worked the most hours to the least
hours on a specific date.I have already tried the acending/decending feature
in query but the results dont reflect this in either query or a report run
from this query.Is there a expression or criteria i need to set in this
field???Thanks
 
Back
Top