If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dates
I have a database that tracks overtime for plowing snow. The first sort of
the report would be on total hours, with the least amount of overtime to the most, and then sorting by seniority date with the company. The problem lies wihen two employees have the same amount of overtime, ex. 41.4 it does not list the most senior employee first. Do I correct this in the sorting and grouping of the report? I have an expression in my query Total Hours: Round(Sum(([hoursworked]*100))), but everywhere I read it appears to me that somehow I should be able to sort in the the sorting and grouping. |
#2
|
|||
|
|||
Dates
Melinda,
You would need to add the field that has Senority Date to Grouping and Sorting and then sort. If this field is not a part of the RecordSource of the report, you will have to do that first. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Melinda" wrote in message ... I have a database that tracks overtime for plowing snow. The first sort of the report would be on total hours, with the least amount of overtime to the most, and then sorting by seniority date with the company. The problem lies wihen two employees have the same amount of overtime, ex. 41.4 it does not list the most senior employee first. Do I correct this in the sorting and grouping of the report? I have an expression in my query Total Hours: Round(Sum(([hoursworked]*100))), but everywhere I read it appears to me that somehow I should be able to sort in the the sorting and grouping. |
Thread Tools | |
Display Modes | |
|
|