Dates

  • Thread starter Thread starter Melinda
  • Start date Start date
M

Melinda

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.
 
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
 
Back
Top