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
 

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

Is it possible to set a sort order based on... 3
sort on multiple fields in an Access query 2
Sorting 2
Return Top 10 Record 6
Concatenated Field - Sort Order 4
Queries? 9
Update Query 2
sort order 1

Back
Top